Granting the Privilege to Truncate a table

[djbjr]

Here is the easy question of the year.

How do you grant a user the privilege to truncate a table on a different schema.

I tried

GRANT truncate on <table_name> to user

But of course that doesnt work. I also looked on the user_tab_privs table and couldnt find the right privilege.

Can any of you DBA's throw a bone to me?

And no Im not asking this for homework help. My DBA's are unavailable becuase they are all trying to figure out how to get the 9i RAC to work. Our Cluster Manager keeps going down.

Thanks,
dj

 

[LKBrwnDBA]

Unfortunately you would have to GRANT DROP ANY TABLE.




----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[djbjr]

You mean drop any table on the whole schema?


I suppose I will have to create a proc that truncates the table and give access to execute the procedure.

thanks

 

[LKBrwnDBA]

Yes, drop any table in ANY schema.

The better solution is to create a procedure and grant execute to authorized users.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb