Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: dynamic SQL with DBMS_SQL
Stored procedures are executed with 'roles' suspended. You need explicit
grants to your executing user to do DDL.
> ERROR at line 1:
> ORA-01031: insufficient privileges
> ORA-06512: at "SYS.DBMS_SYS_SQL", line 239
> ORA-06512: at "SYS.DBMS_SQL", line 25
> ORA-06512: at "HUM_WWW00.DYNSQL", line 6
Received on Mon Jul 14 1997 - 00:00:00 CDT