Subject RE: [firebird-support] Re: change user to DB
Author Alan McDonald
> >
> > > 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
> >
> thanks jhon
> 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?
>

you'll never deny SYSDBA access.
not until a later version of FB
Alan