Revokes roles from a given user.

Syntax

---

REVOKE <RoleName> [,<RoleName>]
FROM <Authorization> [,<Authorization>]

<Authorization> = <UserName>

Usage

---

Use this statement to revoke a role from a user.

Examples

---

-- The following statement revokes the Administrators
-- role from the user "Joe Smith".

REVOKE "Administrators" FROM "Joe Smith"

Required Privileges

---

The current user must be granted the system-defined Administrators role in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations

---

This statement deviates from the SQL 2003 standard in the following ways: