Re: Grant access acrosss SQLNet

Sverre Hjelm wrote:

> Hi,
>
> I have two oracle databases which are connected with SQLNet. Now I need
> to grant from a user on the first database to another user on the second
> database. The obvious sollution;
>
> connect user1_at_database1
> grant select on sometable to user2_at_database2
>
> ...doesn't work -- oracle complains on the @-sign.
>
> So, my question is simply if there is any way to do this, or if grants
> are restricted to users on the
> same database. Please reply with cc to my email. Thanks!
>
> Sverre Hjelm, EUnet Norway

Per my understanding, grants can only be given for objects on the local instance, not for a remote (i.e. connect via SQL*Net) instance.

Hope this helps !

(to reply via email, please change "nospam" to "chavali" in my email address - :-) ) Received on Thu Dec 04 1997 - 00:00:00 CST