Firebird SQL User Management with 2.5 and up

[dolphinbobo]

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.

 

[megaevgen]

Получить Select-запросом всех пользователей сервера в 2.5 нельзя. Только через API (для Delphi например через TIBSecurityService).

 

[PEAKTOP]

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. =)

 

[solover]

EMS SQL Manager for InterBase and Firebird 5.3.0.46603

http://dl.downloadly.ir/Files/Softw...erBase_Firebird_5.3.0.46603_Downloadly.ir.rar

 

[kouvaev]

anyone tried firebird database on android?

На самом устройстве запускать сервер проблематично - не справитесь. Но есть нативный клиент от Firebird 3 на Java для доступа к уделенному серверу (можно и 2.5). Мне через месяц сдавать проект - доступ к базе с планшета на Android. Отпишусь по окончании