REVOKE ROLES

If the clause is specified, the GRANT permission is revoked instead of the role.

The optional clause causes the role(s) to be revoked with the specified principal as a revoker. If the GRANTED BY clause is not specified, the roles are revoked by the current user as a revoker.

Revoke admin option for roles and foo from user baz and role qux

CREATE ROLE, , SET ROLE,