execute procedure over dblink

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Fri, 25 Apr 2008 10:50:49 -0500
Message-ID: <BLU108-W33626F9419D59A32C787FF97DD0@phx.gbl>

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
Received on Fri Apr 25 2008 - 10:50:49 CDT

Original text of this message