Tag Info

New answers tagged


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