Revoking a Compatibility Role

Revoke a compatibility role from a user or role.

Prerequisites
Requires administrative privilege over the compatibility role being revoked.
Task
To revoke a compatibility role, execute one of these statements:
Administrative Option Statement
Administrative rights only

REVOKE ADMIN OPTION FOR ROLE compatibility_role

FROM grantee [,...]

Membership in the role and

any administrative rights

REVOKE ROLE compatibility_role

FROM grantee [,...]
Parent topic: Upgrading to Role-Based Security