Skip to Main Content
Forums

Oracle Database Discussions

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!

-1031 ORA-01031: insufficient privileges by truncate table

rosssteAug 16 2006 — edited Aug 16 2006
Does anybody knows which privilege is missing to the user that using this statement in a stored procedure and who has to grant it?

EXECUTE IMMEDIATE ('truncate table owner.table_name')

The procedure owner has DBA role and also has received grant all from the table owner.
PS. commenting out the statment the procedure work.

Thanx for a quick answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 13 2006
Added on Aug 16 2006
#general-database-discussions
9 comments
5,577 views