Revokes privileges on a given object from a user or role.

Syntax

---

REVOKE <PrivilegeName> [,<PrivilegeName>]
ON <ObjectName>
FROM <Authorization> [,<Authorization>]

<PrivilegeName> =

ALL PRIVILEGES|
SELECT|
INSERT|
UPDATE|
DELETE|
CREATE|
ALTER|
DROP|
MAINTAIN|
BACKUP|
RESTORE|
EXECUTE

<ObjectName> =

DATABASE <DatabaseName>|
STORE <StoreName>|
TABLE <TableName>|
VIEW <ViewName>|
PROCEDURE <ProcedureName>|
FUNCTION <FunctionName>

<Authorization> = <UserName>|<RoleName>

Usage

---

Use this statement to revoke privileges from a user or role.

Examples

---

-- The following statement revokes SELECT privileges
-- on the EmployeesList view from the system-defined
-- Public role which, by default, includes all users.

REVOKE SELECT ON VIEW "EmployeesList"
FROM "Public"

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: