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 -> PL/SQL privileges

PL/SQL privileges

From: Jon <aaa_at_bbb.ccc>
Date: Thu, 20 May 2004 12:04:29 +0200
Message-ID: <c8hvrf$6mc$1@unbe.sarenet.es> 





Hi,



A user has "create any table" privileges and the same user has a procedure
with



"execute immedate 'create table ...'"




when the user tries to run the procedure, it returns the following error



"ORA-01031: insufficient privileges"




thanks
Received on Thu May 20 2004 - 05:04:29 CDT












Original text of this message













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