Ora-01031 when execute immediate 'create table ...'
Posted on 2004-04-26
Dear advisor !
i have user leaseline with connect, resource, DBA role.
I have a 'CreateData' procedure and i could run it well before. Now, i run it with error.
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "LEASELINE.CreateData", line 3
ORA-06512: at line 1
the CreateData procedure
Execute Immediate 'Create table aaaaaaaaaaa (a varchar2(1))' ;
Please show me how to corecct it. Maybe, i have change some configure at Oracle , but i do not remember.
Thank for all consider