New answers tagged truncate
You can give DROP ANY TABLE system privilege to A, then he will be able to truncate everything in any schema (not just in B's though) . If you don't want to do that, a simple stored procedure created by B will do the job (procedure or function in Oracle are by default executed with definer rights) . Then you give need execute permission to A on this ...
Top 50 recent answers are included