RE: execute procedure over dblink
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.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joe Smith Sent: Friday, April 25, 2008 10: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'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.comReceived on Fri Apr 25 2008 - 11:28:46 CDT