Hi, thank you. I plan on using my own system administrative account - hence not the default SYSDBA account. I will connect to security2.fdb to locate the users table and will post If I have trouble.
Regards Danie van Eeden On 7/10/2012 7:54 AM, Thomas Steinmaurer wrote: > > > 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 > > > > > > > > [Non-text portions of this message have been removed]
