One of those occasional grants that you really wish you could grant. You have a large temporary table that the Devs are using for testing developments, but it’s not in a schema they control. They need to clean it down regularly, but you don’t want them blowing up loads of redo logging by using deletes. So letting them truncate the table sounds like the best idea.
Except in Oracle that’s a grant you can’t grant. As far as Oracle’s concerned truncating a table is the same as dropping a table. So you either need to grant the Developer ‘DROP ANY TABLE’ or ‘DBA’, neither of which are what you want to do as they grant them the ability to drop anything in the instance, or do even more damage.
So, the workaround? Well, create a stored procedure owned by the table owner which truncates the table, and grant