RE: execute procedure over dblink
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.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Joe Smith
Sent: Friday, April 25, 2008 9:51 AM
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?
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?Received on Fri Apr 25 2008 - 14:21:36 CDT