Zeoslib Portal

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

Hi Josef,

maybe this will give you an overview ...

• "Security - Enhanced isc4.gdb"

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.