Re: Creating DB link inside stored procedure

From: <kathar.km_at_gmail.com>
Date: Thu, 26 Jul 2007 22:07:14 -0000
Message-ID: <1185487634.857048.321510@l70g2000hse.googlegroups.com>

On Jul 26, 2:53 pm, Ronny <nitely..._at_ist-einmalig.de> wrote:
> "grant create public database link to <user>" ... is the key.
>
> Within PL/SQL Oracle ignores all grants given by roles. It's a
> feature, not a bug. There's a Metalink Note around explaining it, but
> sorry, I can't remember the exact id by heart...
>
> Ronny

Thanks Ronny and NetComrade. I really appreciate your help on this. You saved me !!! Received on Thu Jul 26 2007 - 17:07:14 CDT