> I'm new to Firebird and still constructing backend units for application development. I;m writing code in Delphi using Zeoslib.
>
> I am struggling to find the system relation / table containing existing users (including the system administrative user (SYSDBA)).
>
> The idea is to provide any System Admin (in this case my application together with SYSDBA login details) access via a user interface to maintain database existing users of firebirddb. That is, view existing users and add new users via 'Create User'. Where would I find such users table (RDB$Users) if such exists? Or am I going about this the wrong way?

Users are stored instance-wide in a security database called
"security2.fdb" located in the Firebird root directory.

To manage users in Firebird 2.5, there are the following ways:

* CREATE/ALTER/DROP USER ... DDL statement (new in 2.5)
* Use the gsec command-line tool, located in the Firebird\bin directory
* Use the Services API


Btw, move away from using the SYSDBA as your database and database
objects owner. This will save you from various problems when you are
deploying a Firebird-based application to an existing Firebird server
installation, where you don't have access to the SYSDBA password
permanently.


Hope this helps.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

> Kind Regards
> dve83
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>