July 22nd, 2009
Data Control Language, REVOKE
Posted by
admin in
R. Data Control Language
Format: REVOKE {SELECT | INSERT | UPDATE | DELETE | REFERENCES} [column_names]
ON {table_name | view_name}
TO {user_id | PUBLIC} [CASCADE | RESTRICT];
The privileges that have been granted with the GRANT statement can be removed with the REVOKE statement. The REVOKE statement syntax is very similar to the GRANT syntax. It simply says that you are removing privileges on specific database objects from one or more database users.
> Many RDBMS systems use a REVOKE similar to DB2′s format which allows you to specify a list of tables and a list of user-IDs. This makes it easier to revoke many privileges at once.
Comments Off
