Re: dynamic SQL with DBMS_SQL

From: Roger Snowden <rsnowden_at_IHateSpam.com>
Date: 1997/07/14
Message-ID: <01bc90a1$3f3fa000$096fc589_at_RSNOWDEN.labinterlink.com>#1/1


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 CEST

Original text of this message