Subject Re: [firebird-support] Usernames & Passwords
Author Helen Borrie
At 09:18 PM 21/10/2008, you wrote:
>Hello All
>
>Is it possible to set a different admin Username & password for each
>Database?
>
>ie database1 has username=SYSDBA password=1234
> database2 has username=SYSDBA password=5678
> database3 has username=SYSDBA password=9012

No. Firebird doesn't have database-level authentication yet.

What you want to do here, in fact, is create an admin user for each
database, i.e. a user that has admin privs on only the one
database. Really, you shouldn't have any databases that are owned by SYSDBA.

So admin1 would be Owner of database1, admin2 of database2 and so
on. Build the databases by script while logged in as the appropriate
admin and you have it.

./heLen