Subject | Re: [firebird-support] Re: change user to DB |
---|---|
Author | John vd Waeter |
Post date | 2010-04-27T12:20:06Z |
> it's all right, but if i a Server_a with SYSDBA user with password Mickey and on server_b SYSDBA user with password Donald the user have access to db because is the same. I want grant access only at one user without SYSDBA user.If I understand you correctly you have a database created by user SYSDBA
and you want to give access to this database by a later created user.
If so, you can GRANT privileges for this database to the new user. The
privileges go object by object, so you'll have to grant privileges to
the new user for every table, sp etc.
This is an easy job using a tool like Flamerobin...
kind regards,
John