Subject Re: [firebird-support] Some security questions
Author Helen Borrie
At 07:43 AM 22/10/2004 +0200, you wrote:

>Hello,
>
>I read some stuff about FireBird security in Helen's book, and as I
>understand, it hat two phases, server and database, right ?
>Servers password is stored in security.fdb, right?
>About changing password, there was a subject yesterday in this group, this
>password belongs to server side ?
>Are database passwords handled by gsec too ?

Firebird security hasn't changed since the book was written. :-) So there
are no "database passwords". If you read Chapter 35, you will find it is
about using SQL permissions for database-level security.


>If I want to have multiply users with own passwords, should they be set in
>server and database ?
>What do I have to set where ?

Only in the server. If you want database-level passwords, you will have to
"roll your own" for now.


>If I set servers users and passwords, how should I backup then this things,
>if there is neccesity to reinstall server. Just save the security.fdb ?

security.fdb is just a database. Back it up just like any other
database. Keep the backup secure, though, i.e. store the backup file onto
a CD to be kept in the safe, and delete the original backup.

./heLen