RE: execute procedure over dblink

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joe Smith
Sent: Friday, April 25, 2008 9:51 AM
To: oracle-l_at_freelists.org
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?

--
http://www.freelists.org/webpage/oracle-l