Neoview SQL Reference Manual (R2.5)

privilege [,privilege]... | all [PRIVILEGES]
specifies the privileges to revoke. You can specify each of these privileges for a schema.
Any table, view, materialized view, or procedure created in the schema after this
privilege is granted will be able to perform any DDL privilege including CREATE,
DROP, ALTER, and the REFRESH option of MAINTAIN.
ALL_DDL
Any table, view, materialized view, or procedure created in the schema after this
privilege is granted will be able to perform any DML privilege including DELETE,
EXECUTE, INSERT, REFERENCES, SELECT or UPDATE.
ALL_DML
Revokes the ALTER privilege, which includes materialized views, materialized view
groups, synonyms, tables, triggers, and views.
ALTER
Revokes the privilege to alter a materialized view.ALTER_MV
Revokes the privilege to change the list of materialized views to refresh together.ALTER_MV_GROUP
Revokes the privilege to change a synonym.ALTER_SYNONYM
Revokes the privilege to add and drop constraints; add, populate, and drop indexes;
add, alter, and drop triggers; modify file attributes; add columns, and rename tables
for any table in the schema.
ALTER_TABLE
Revokes the privilege to enable or disable triggers.ALTER_TRIGGER
Revokes the privilege to alter a view definition.ALTER_VIEW
Revokes the ability to use all CREATE privileges, which includes materialized views,
materialized view groups, synonyms, tables, triggers, and views.
CREATE
Revokes the privilege to create a materialized view.CREATE_MV
Revokes the privilege to create materialized views groups.CREATE_MV_GROUP
Revokes the privilege to create stored procedures in the schema.CREATE_PROCEDURE
Revokes the privilege to create a synonym.CREATE_SYNONYM
Revokes the privilege to create a table.CREATE_TABLE
Revokes the privilege to create a trigger.CREATE_TRIGGER
Revokes the privilege to create a view.CREATE_VIEW
Revokes the ability to use the DELETE statement.DELETE
Revokes the ability to use all DROP privileges, which includes materialized views,
materialized view groups, synonyms, tables, triggers, and views.
DROP
Revokes the privilege to drop a materialized view.DROP_MV
Revokes the privilege to drop materialized view groups.DROP_MV_GROUP
Revokes the privilege to drop stored procedures in the schema.DROP_PROCEDURE
Revokes the privilege to drop synonyms in the schema.DROP_SYNONYM
Revokes the privilege to drop tables.DROP_TABLE
Revokes the privilege to drop any trigger in the schema.DROP_TRIGGER
Revokes the privileges to drop any regular view in the schema.DROP_VIEW
Revokes the EXECUTE privilege on a schema.EXECUTE
Revokes the ability to use the INSERT statement.INSERT
Revokes constraints that reference the schema.REFERENCES
Revokes the ability to use the SELECT statement.SELECT
Revokes the ability to use the UPDATE statement.UPDATE
All of the privileges above. Can have all privileges that apply to the object type.ALL PRIVILEGES
ON SCHEMA schema-name
specifies a schema on which to revoke privileges.
REVOKE SCHEMA Statement 161