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: stored procs executing DDL

Re: stored procs executing DDL

From: Jörgen Ekroth <jorgen.ekroth_at_lycosmail.com>
Date: Sun, 20 Jun 1999 21:24:12 +0200
Message-ID: <376D3FDC.6BB9AF1C@lycosmail.com> 





Hi Cindy,



For some reason privileges granted via roles are disabled when executing
stored procedures, so system privileges must be granted explicitly to users
for this to work. Try connecting as "sys" or "internal" and do "GRANT CREATE
TABLE TO SYSTEM" and re-run the procedure.



Cheers!


/Jorgen


Received on Sun Jun 20 1999 - 14:24:12 CDT












Original text of this message













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