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]