Hav you entered "AUTHID CURRENT_USER " to the procedure?
Another solution is to grant create any table, but I would not recommend
that.

/Anders

The information contained in this communication is confidential
and is the property of the Sender.
It is only intended for the use of the Addressee.


|---------+--------------------------------->
| | " Rahul" |
| | <rahul.[Email Address Removed] | ftware.com> |
| | |
| | 02/27/2004 12:48 PM |
| | |
|---------+--------------------------------->
>------------------------------------------------------------------------------------------------------------------------------|
| |
| To: "LazyDBA.com Discussion" <[Email Address Removed] |
| cc: |
| Subject: dbms_sql causes insufficient previleges when called from a function or proc |
>------------------------------------------------------------------------------------------------------------------------------|




hi gurus,
i am trying to create a table using dbms_sql in a procedure .
when i create the proc , it is created with out any erros .
but when i execute the proc , i get in sufficient previleges error.
please help .
note that when i use truncate , instead of create , it allows me to execute
the proc .

Rgds
Rahul





Oracle LazyDBA home page