RE: execute procedure over dblink
- From: <krish.hariharan@xxxxxxxxxxxx>
- To: <joe_dba@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 25 Apr 2008 13:21:36 -0600
Check if the user (in the dblink) on the far side has execute on the object
either directly or through a role. And while you are at it also verify if
there is a synonym exists (if object is not fully qualified) should the user
and the owner be different.
If the user and owner are the same then the above won't apply and would have
to diagnose that.
-Krish
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Joe Smith
Sent: Friday, April 25, 2008 9:51 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: execute procedure over dblink
I have a dblink from db A to db B. I am inserting data into tables in db A
from db B by selecting. The link works fine.
I have just put a procedure in db B and I am trying to execute the procedure
from db A , but I am getting an "insufficient privileges" error. What am I
missing?
thanks.
_____
Back to work after baby- how do you know when you
<http://lifestyle.msn.com/familyandparenting/articleNW.aspx?cp-documentid=57
97498&ocid=T067MSN40A0701A> 're ready?
Other related posts:
