Revoking a System Role

Revokes a system role from a user or role.

Prerequisites

Administrative privilege over the system role being revoked.

Task

To revoke a system role, execute:

REVOKE ROLE role_name FROM grantee [,...]

Example:

This statement revokes the dbo system role entirely from Mary:

REVOKE ROLE dbo FROM Mary