Re: Insufficient privileges to analyze an object

From: bonminh lam <hansmayer1962_at_hotmail.com>
Date: 17 May 2002 05:10:14 -0700
Message-ID: <3c6b1bcf.0205170410.e8b2a0a@posting.google.com>

Thank you, Stephan. That makes sense.

"Stephan Bressler" <stephan.bressler_at_pdb.sbs.de> wrote in message news:<ac03ha$muk$1_at_news.mch.sbs.de>...
> Hi,
>
> the grant "analyze any" is inherited by system via the role DBA. PL/SQL only
> supports direct grants.
> After "grant analyze any to system" (works even if connected as system!),
> your procedure should be executeable by system.
>
> Regards
> Stephan
Received on Fri May 17 2002 - 07:10:14 CDT