Subject | Re: change user to DB |
---|---|
Author | ciccios78 |
Post date | 2010-04-27T12:23:39Z |
--- In firebird-support@yahoogroups.com, John vd Waeter <john@...> wrote:
if i grant all object for the new user and remove the privilege for SYSDBA i have all access only for the new user, right?
>thanks jhon
> > 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
>
if i grant all object for the new user and remove the privilege for SYSDBA i have all access only for the new user, right?