Subject Re: change user to DB
Author ciccios78
--- In, John vd Waeter <john@...> wrote:
> > 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?