Description
- ALL or ALL PRIVILEGES
- Revokes one or more privileges from each authorization-name. The privileges revoked are those privileges on the identified tables
and views that were granted to the authorization-names. Note that revoking ALL PRIVILEGES on a table or view is not the same
as revoking the system authority of *ALL.
If you do not use ALL, you must
use one or more of the keywords listed below. Each keyword revokes the privilege
described, but only as it applies to the tables and views named in the ON
clause.
- ALTER
- Revokes the privilege to use the ALTER TABLE statement on tables. Revokes
the privilege to use the COMMENT and LABEL statements on tables and views.
- DELETE
- Revokes the privilege to use the DELETE statement.
- INDEX
- Revokes the privilege to use the CREATE INDEX statement.
- INSERT
- Revokes the privilege to use the INSERT statement.
- REFERENCES
- Revokes the privilege to add a referential constraint in which the table
is a parent.
- REFERENCES (column-name,...)
- Revokes the privilege to add a referential constraint using the specified
column(s) in the parent key. Each column name must be an unqualified name
that identifies a column in each table identified in the ON clause.
- SELECT
- Revokes the privilege to use the SELECT or CREATE VIEW statement.
- UPDATE
- Revokes the privilege to use the UPDATE statement.
- UPDATE (column-name,...)
- Revokes the privilege to update the specified columns. Each column
name must be an unqualified name that identifies a column in each table identified
in the ON clause.
- ON table-name or view-name, ...
- Identifies the table or view on which you are revoking the privileges.
The table-name or view-name must
identify a table or view that exists at the current server, but must not identify
a global temporary table.
- FROM
- Identifies from whom the privileges are revoked.
- authorization-name,...
- Lists one or more authorization IDs. Do not specify the same authorization-name more than once.
- PUBLIC
- Revokes the specified privileges from PUBLIC.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.