Grant access acrosss SQLNet

From: Sverre Hjelm <shjelm_at_csulb.edu>
Date: 1997/12/02
Message-ID: <34844558.4D7125A0@csulb.edu>#1/1

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 Received on Tue Dec 02 1997 - 00:00:00 CST