Firebird SQL User Management with 2.5 and up

  • Автор темы dolphinbobo
  • 2584
  • Обновлено
  • 25, Sep 2014
  • #1
Bonjour The link hereafter provides some information on the subject :
http://www.firebirdsql.org/refdocs/langrefupd25-security-sql-user-mgmt.html

Where can I get more information and especially on how to retrieve all the users registered on a server and on a database within that server with some simple sql constructions like "select ...." to be "executed" in a delphi program ? Thank you.

dolphinbobo


Рег
19 Dec, 2006

Тем
6

Постов
6

Баллов
66
  • 15, Oct 2014
  • #2
Получить Select-запросом всех пользователей сервера в 2.5 нельзя. Только через API (для Delphi например через TIBSecurityService).
 

megaevgen


Рег
05 May, 2009

Тем
0

Постов
7

Баллов
7
  • 02, Jan 2016
  • #3
FirebirdSQL has client-server architecture.

If You have an access to database file, You have access to all data.

So, my advice to You is: You should to stop wasting time on nonsense actions.

--------------

There is an dirty hack:

1) create user "MY_INTERNAL_USER".

2) grant all rights in the database to user "MY_INTERNAL_USER"

3) login to database with user "MY_INTERNAL_USER"

4) create role "SYSDBA" in the database.

5) revoke all rights from role "SYSDBA"

After that, You can to connect with "SYSDBA" to database.

But You cannot to see any object (table/view/procedure/etc..). when You are installing Your software to customer, You should to create user "MY_INTERNAL_USER" programatically when installing process is in progress.

Because Firebird(2.5 and lower) does not to store users in database.

It stores users in his own users-database "SECURITYXX.FDB". ---------- This dirty hack cannot to stop Firebird-DBA to connect to Your data. But it can to stop Script kiddie. =)
 

PEAKTOP


Рег
06 Apr, 2009

Тем
7

Постов
14

Баллов
84
  • 31, Jul 2016
  • #5
machitza, post: 760464:
anyone tried firebird database on android?
На самом устройстве запускать сервер проблематично - не справитесь. Но есть нативный клиент от Firebird 3 на Java для доступа к уделенному серверу (можно и 2.5). Мне через месяц сдавать проект - доступ к базе с планшета на Android. Отпишусь по окончании
 

kouvaev


Рег
23 Mar, 2009

Тем
2

Постов
16

Баллов
36
Тем
49554
Комментарии
57426
Опыт
552966

Интересно