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 -> Re: Insufficient privileges to analyze an object

Re: Insufficient privileges to analyze an object

From: Stephan Bressler <stephan.bressler_at_pdb.sbs.de>
Date: Thu, 16 May 2002 13:00:57 +0200
Message-ID: <ac03ha$muk$1@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 Thu May 16 2002 - 06:00:57 CDT












Original text of this message













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