Re: Privileges Database Link

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Mon, 24 May 2010 22:49:24 +0200
Message-ID: <4bfae659$0$22920$e4fe514c_at_news.xs4all.nl>

Op 24-5-2010 20:18, The Magnet schreef:
>
> We have 2 database which have DB links between. The user in both
> database have the same name. We cannot figure out how to grant the
> privileges.
>
> SQL> grant select on status to john_at_comm.zacks.com;
> grant select on status to john_at_comm.zacks.com
> *
> ERROR at line 1:
> ORA-00933: SQL command not properly ended
>
>
> SQL> grant select on status to john;
> grant select on status to john
> *
> ERROR at line 1:
> ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
>
> Help please.
>

Your database link connects through a user in the target database. Grants should be done IN the target database by an account with the privileges to do so. You can not grant over the link.

Shakespeare Received on Mon May 24 2010 - 15:49:24 CDT