Re: dynamic SQL question

steve_young wrote
>SQL> execute exec('create table t(f integer)');
>ORA-01031: insufficient privileges

The Oracle user that issues this exec('create table t(f integer)') simply has not the proper privilges to do so. Note that users should get those privileges explicitly (like: grant create table to scott) and not by a role if you need them in stored procedures. Oracle uses early binding for stored procedures but can not determine if a role has changed when running a stored procedure, so explicit grants are needed.

Arjan. Received on Thu Jan 07 1999 - 00:00:00 CST