Subject Re: [firebird-support] User's Accounts
Author Helen Borrie
Dimitar,

At 04:10 PM 1/08/2008, you wrote:
>Hello All!
>
>I have some problem... I am new in FireBird. (I have FireBird 2.0
>server with a small database). And I want to change the server.
>All what I do is:
>I stop FireBird Instans on server.
>Copy Database Files to other server.
>Start FireBird Instanse on the new server...
>With IBExpert I register the database on the new server...
>
>All seems to be fine except user's password...
>I don't know how to transfer user information on the new server.
>I copy all database files (including file "security.fdb". Looks lile
>user's information is copied to the new server except user's password.

"security.fdb" is the user authentication database for Firebird 1.5. It does not work under a Firebird 2 server. Simply renaming it will not make it work: you must read the Firebird 2 release notes and follow the instructions for upgrading your old "security.fdb" to "security2.fdb" for use with Firebird 2 and 2.1 servers.

>I want to make all this invisible to user... I don't want ask them to
>reenter their password...

If you perform the conversion according to instructions, the existing passwords should remain intact.

In a later message you wrote:
>> Why second database haven't security.fdb file? When I move this
database to the new server I lose the passwords too...
<<


There is only ONE authentication database on a server. User authentication operates at *server* level, not at database level.

./heLen