Re: Create database link from inside a stored procedure

From: Dave <solomons_dad.w.marks_and_whom_at_oracle.com>
Date: Tue, 28 Mar 2006 17:04:15 +0100
Message-ID: <7pdWf.34$Nb2.33@news.oracle.com>

Jeremy wrote:
> 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.
>
>
>

Is the privilege granted directly or through a role?

Dave. Received on Tue Mar 28 2006 - 10:04:15 CST