Hi Friends,

I'm trying to create a table with this command:

execute immediate 'create table aaa .........' ;

in a Package Body.

I receive the following error:

ORA-01031 Insufficient privileges

(ORACLE 9i)

What is the Problem?

Thank you in advance!

Hi

You'll need an EXCPLICIT grant for the create table privilege:

SQL> GRANT CREATE TABLE TO <user_who_is_executing_procedure>

Good luck

Remi

------------------------
Many many tanks for you help to all my daily questions!

Gratefully
Pappagone

You are very welcome!!