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 -> execute immediate insufficient privilege error

execute immediate insufficient privilege error

From: Faraz <sarfarazlatif_at_gmail.com>
Date: Fri, 10 Aug 2007 06:59:53 -0700
Message-ID: <1186754393.623674.116630@d30g2000prg.googlegroups.com> 





HI all,


I am trying to rebuild an index  in a procdeure but some how getting
the error below


ERROR at line 1:

ORA-01031: insufficient privileges
ORA-06512: at "SCHD.CLEANUP", line 33
ORA-06512: at line 1





the owner of package and the index is the same user who invokes the
procedure to do this task.



any help will be appreciated.
Received on Fri Aug 10 2007 - 08:59:53 CDT












Original text of this message













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