RE: execute procedure over dblink

  • From: "Elliott, Patrick" <patrick.elliott@xxxxxxxxxxxxx>
  • To: "joe_dba@xxxxxxxxxxx" <joe_dba@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 25 Apr 2008 11:28:46 -0500

If the privileges used to insert the rows are granted through a role, then this 
will not work.
Grant the privileges directly.


Pat



________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Joe Smith
Sent: Friday, April 25, 2008 10: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're 
ready?<http://lifestyle.msn.com/familyandparenting/articleNW.aspx?cp-documentid=5797498&ocid=T067MSN40A0701A>

[CONFIDENTIALITY AND PRIVACY NOTICE]

Information transmitted by this email is proprietary to Medtronic and is 
intended for use only by the individual or entity to which it is addressed, and 
may contain information that is private, privileged, confidential or exempt 
from disclosure under applicable law. If you are not the intended recipient or 
it appears that this mail has been forwarded to you without proper authority, 
you are notified that any use or dissemination of this information in any 
manner is strictly prohibited. In such cases, please delete this mail from your 
records.
 
To view this notice in other languages you can either select the following link 
or manually copy and paste the link into the address bar of a web browser: 
http://emaildisclaimer.medtronic.com

Other related posts: