Removes object-level privileges that were given using the GRANT statement.
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
REVOKE INSERT ON Employees FROM Dave
REVOKE UPDATE ON Employees FROM Dave
SQL–Syntax is an entry-level feature.
Sybase–Syntax is supported in Adaptive Server Enterprise.