Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Execute immediate : permition denied for TRUNCATE talble

muttleychessApr 24 2007 — edited Apr 24 2007
Hi

In my package I have Execute immedidate
  EXECUTE IMMEDIATE 'TRUNCATE TABLE  MYTABLE'; 
Return me permission denied , I must to veirfy with DBA my permissions

My ask is : is there some statment in package/procedure that I do not rembember that let it with permissions ?

I remember something like authid
Somebody know ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 22 2007
Added on Apr 24 2007
3 comments
227 views