SQL REVOKE Clause

Go back

The opposite of GRANT to take back privilege on users/roles.

REVOKE xxx ON sometable TO someuser;

If A granted a privilege to B, but we revoke a privilege for A, then B will also have it revoked, unless they still have a "granter" with the privilege.