Subject | Re: [firebird-support] user accounts |
---|---|
Author | Thomas Steinmaurer |
Post date | 2011-10-14T17:49:29Z |
> I would like to ask :Firebird users are stored in a instance-wide Firebird database called
>
> 1. How to select the list of "user accounts" from my firebird database
> (2.5 super server)
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 cpuSee above. Create a backup of your database and move security2.fdb to
> including my user accounts. Because my problem is when i restore to
> another cpu then the user accounts is gone and just left 'SYSDBA'.
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