Insufficient Privileges (execute immediate)
Posted on 2001-08-15
I created the following stored procedure for
dinamycally execute a DDL Sentence.
procedure ejecuta (sentence in varchar2)
execute immediate sentence;
And it works well for DML Sentences, but
when I try to execute a DDL sentence like:
create table a (a number);
I receive an ORA-01031: Insufficient Priveleges
But the user that executes and owns the stored
procedure has DBA privileges.
If someone has any idea, please help me, I
will be grateful, if you do so ...