how to revoke multiple users permission from multiple tables at the same time? Or in simple is there a way to revoke multiple users grant access from multiple tables under a schema.?
I use Revoke below command to execute on each table one by one. revoke SELECT/ALL on testtable from user1; Thanks for taking your time to read this. thanks Deepak