Removing Members from a User-Defined Role

Remove a user or role as a member of a role. The user or role loses the ability to use any underlying system privileges or roles of a role, along with the ability to administer the role, if granted.

Prerequisites
Administrative privilege over the role being managed.
Task
A minimum number of role or global role administrators (as defined by the MIN_ROLE_ADMINS database option) with a login password must exist for each role at all times. If the member is an administrator of the role and his or her removal violates the minimum requirement, the removal fails.
To remove membership in a user-defined role from a grantee, execute one of these statements:
Revoke Type Statement

Role membership and

all administrative rights to the role

REVOKE ROLE role_name

FROM grantee [,...]

Administrative rights

to the role only

REVOKE ADMIN OPTION FOR ROLE role_name

FROM grantee [,...]
Parent topic: User-Defined Roles
Related reference
REVOKE ROLE Statement