| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_SQL
Yes indeed, the way ORACLE handles the privileges is different for
anonymous PL/SQL blocks and stored procedures. I had the same problem
and the ORACLE Hotline Germany gave me that answer. You have to issue a
'GRANT CREATE TABLE TO <user_in_question>' statement in order to get the
stored procedure working.
Good luck,
Chris
-- Christoph Ganz IDS Prof. Scheer GmbH Altenkesseler Str. 17 66115 Saarbruecken Tel +49 681 9921 660 Fax 501Received on Mon May 12 1997 - 00:00:00 CDT
 |
 |