Skip to Main Content

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!

grant truncate privilege

52365May 13 2009 — edited May 14 2009
We are using 10.2 and need truncate privilege on tables we are bulk loading. When our security group executes the 'grant select' on a table for our role it works but when they execute a 'grant truncate' on the same table it fails because of privileges. What privilege does our role need before it can be granted the truncate privilege? I have found nothing in the documentation and our DBA does not know.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 11 2009
Added on May 13 2009
6 comments
24,284 views