Re: [firebird-support] Newbie: Viewing system users
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]
Re: [firebird-support] Newbie: Viewing system users
2012/7/10 Danie van Eeden vaneeden.da...@gmail.com ** I will connect to security2.fdb to locate the users table and will post If I have trouble I think you can't connect no more to security2.fdb with firebird 2.5. You will have to get users trough API. Regards, Jesus [Non-text portions of this message have been removed]
[firebird-support] Newbie: Viewing system users
Hi, 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? Kind Regards dve83
Re: [firebird-support] Newbie: Viewing system users
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
