> 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
