revoke

Hi, what is the command to revoke all grants from a particular schema for a single user.


thanks,

there is no command, you will have to loop through and do them one by one

There is no single revoke statement to do that; you have to revoke privs one at a time.

Hint: You can always write a query to generate all the statements you need.