> 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 > > >
