Subject | Re: [firebird-support] Firebird sysdba account |
---|---|
Author | Helen Borrie |
Post date | 2008-08-14T14:50:19Z |
At 23:13 14/08/2008, you wrote:
And you might also have missed the point that the database owner doesn't have any privileges to any objects that were created by another user, including SYSDBA - SO MAKE SURE YOU LOG IN AS OWNER WHEN YOU CREATE OR ALTER OBJECTS !!
./heLen
>This is what I have tried.Yes, you've missed the point that SYSDBA has full destructive rights to ALL databases on the server. The Owner has similar rights only to the database it owns (but it can't operate on the security database: only SYSDBA can do that.)
>
>1. Created new user/password using gsec.
>2. Created new database using the new user as the owner.
>
>But, I can still connect to this new database using SYSDBA/masterkey credential. Am I missing anything?
And you might also have missed the point that the database owner doesn't have any privileges to any objects that were created by another user, including SYSDBA - SO MAKE SURE YOU LOG IN AS OWNER WHEN YOU CREATE OR ALTER OBJECTS !!
./heLen