Subject Re: [firebird-support] user accounts
Author Thomas Steinmaurer
> I would like to ask :
>
> 1. How to select the list of "user accounts" from my firebird database
> (2.5 super server)

Firebird users are stored in a instance-wide Firebird database called
security2.fdb and not in your database. To get a list of currently
created users, use either the gsec command-line utility or in your
application via the Firebird client API or via some comopnent depending
on your access libraries (are you using Delphi?).

> 2. How to backup (and restore) completely my database to another cpu
> including my user accounts. Because my problem is when i restore to
> another cpu then the user accounts is gone and just left 'SYSDBA'.

See above. Create a backup of your database and move security2.fdb to
the new server. Don't copy security2.fdb while your Firebird server is
running.

> note : i use "gbak" to backup and restore, my OS is Win 7 and FB 2.5 SS.


--
With regards,
Thomas Steinmaurer

* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/

* Upscene Productions - Database Tools for Developers
http://www.upscene.com/

* My Blog
http://blog.upscene.com/thomas/index.php