REVOKE Object-Level Privilege Statement

Removes object-level privileges that were given using the GRANT statement.

Syntax

REVOKE {permission [,...]
ON [ owner.]table-name 
FROM userID [,...]

permission
ALL [ PRIVILEGES ] 
| ALTER 
| DELETE 
| INSERT
| REFERENCE [ ( column-name [, …] ) ] 
| SELECT [ ( column-name [, …] ) ] 
| UPDATE [ ( column-name, …) ] }
| LOAD
| TRUNCATE

Parameters

userID – must be the name of an existing user or role that has a login password. Separate multiple userIDs with commas.

Examples

Example 1 – prevents user Dave from inserting into the Employees table.
```
REVOKE INSERT ON Employees FROM Dave 
```
Example 2 – prevents user Dave from updating the Employees table.
```
REVOKE UPDATE ON Employees FROM Dave 
```

Standards

SQL–Syntax is an entry-level feature.
Sybase–Syntax is supported in Adaptive Server Enterprise.

Permissions

You either:

Own the table, or
Have the MANAGE ANY OBJECT PRIVILEGE system privilege granted with the GRANT OPTION clause.

Parent topic: SQL Statements

Related reference

GRANT Object-Level Privilege Statement

Created May 23, 2013. Send feedback on this help topic to Technical Publications: pubs@sybase.com