Icon REVOKE PRIVILEGES

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:

DeviationDetails
HIERARCHY OPTION FORElevateDB does not support the HIERARCHY OPTION FOR clause.
GRANT OPTION FORElevateDB does not support the GRANT OPTION FOR clause. Only administrators can revoke privileges and roles in ElevateDB.
GRANTED BYElevateDB does not support the GRANTED BY clause. The grantor in ElevateDB is always the administrator executing the GRANT statement.
RESTRICT or CASCADEElevateDB does not support the RESTRICT or CASCADE clauses.
PrivilegesElevateDB does not support the REFERENCES, USAGE, TRIGGER, and UNDER privileges, and adds the CREATE, ALTER, DROP, MAINTAIN, BACKUP, and RESTORE privileges as extensions.
Image