Granting priviledges on a synonym using a database link
From: roxane edjlali <re>
Date: 1995/10/19
Message-ID: <465u4d$p4t_at_sndsu1.sedalia.sinet.slb.com>#1/1
Roxane Edjlali
email : redjlali_at_houston.geoquest.slb.com
Received on Thu Oct 19 1995 - 00:00:00 CET
Date: 1995/10/19
Message-ID: <465u4d$p4t_at_sndsu1.sedalia.sinet.slb.com>#1/1
I have 2 database instances A and B.
A has a user account A1 containing
a table T1.
B has a user account B1 with a database link to A1.
I have defined a synonym T'1 in B1 for T1_at_A1.
I have a second user on B called B2.
When connected to B1 I try to give insert, select priviledges to B2 on T'1.
Oracle gives the following error message :
ORA-02021: DDL operations are not allowed on a remote database.
Is there any way of getting around this pb?
I would like to avoid creating a second
database link between B2 and A1.
Roxane Edjlali
email : redjlali_at_houston.geoquest.slb.com
Received on Thu Oct 19 1995 - 00:00:00 CET