Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Create database link from inside a stored procedure

Create database link from inside a stored procedure

From: Jeremy <jeremy0505_at_gmail.com>
Date: Tue, 28 Mar 2006 15:00:44 +0100
Message-ID: <MPG.1e935feb4868abe598a151@news.individual.net>

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_plsql
Received on Tue Mar 28 2006 - 08:00:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US