how to revoke multiple users permission from multiple tables at the same time?

[DM <dm.aeqa@xxxxxxxxx>]

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