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.