Hello,
I would like to create a usw administration not with IBExpert, ect. I would like to create a own form i a delphi application to do this.
I got postings that I need the security.fdb. Other's handle this with a component like
TIBSecurityService or
TFIBSecuServ
Is there a possibilty to handle this security.fdb (create new users , delete or edit users with password handling, ect.) with the ZEOS components?
Best regards
Josef
ZEOS, firbird and security.fdb
Moderators: gto, cipto_kh, EgonHugeist
Hi Josef,
maybe this will give you an overview ... The informations are also valid for Firebird's security.fdb.
All GRANT and REVOKE actions concerning user rights on a FB/IB database can be executed using a TZQuery since they are "normal" SQL statements.
To get more informations about privileges, please take a look at the FB "Operations Guide", Chapter "Database Security" and the FB "Language Reference" (GRANT and REVOKE statement). Also have a look at the chapter "System tables and Views" of the "Language Reference".
The documentatios are downloadable from here.
Regards.
maybe this will give you an overview ... The informations are also valid for Firebird's security.fdb.
All GRANT and REVOKE actions concerning user rights on a FB/IB database can be executed using a TZQuery since they are "normal" SQL statements.
To get more informations about privileges, please take a look at the FB "Operations Guide", Chapter "Database Security" and the FB "Language Reference" (GRANT and REVOKE statement). Also have a look at the chapter "System tables and Views" of the "Language Reference".
The documentatios are downloadable from here.
Regards.