Subject | Re: [firebird-support] Usernames & Passwords |
---|---|
Author | Helen Borrie |
Post date | 2008-10-21T12:52:46Z |
At 09:18 PM 21/10/2008, you wrote:
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
>Hello AllNo. Firebird doesn't have database-level authentication yet.
>
>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
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