Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Create database link from inside a stored procedure
Hi there - if an Oracle account that has privileges to create a database link tries to run a stored procedure owned by the same account and whilst connected to the same account, why should one get an "insufficient privileges" error / what privileges might be required?
e.g.
15:49:22 SQL> create database link mylink
2 connect to a identified by b using 'c' ;
Database link created.
But the same statement in an "execute immediate" inside a stored procedure gets an ORA-01031: insufficient privileges
Thanks for any pointers.
-- jeremy We use Oracle 9iR2 on Solaris 8 with the Oracle HTTP Server and mod_plsqlReceived on Tue Mar 28 2006 - 08:00:44 CST