Neoview SQL Reference Manual (R2.3)

REVOKE SCHEMA Statement
• “Syntax Description of REVOKE SCHEMA”
• “Considerations for REVOKE SCHEMA”
• “Examples of REVOKE SCHEMA”
The REVOKE SCHEMA statement revokes access privileges for a Neoview SQL schema from
specified roles. See also“ROLLBACK WORK Statement” (page 143).
REVOKE [GRANT OPTION FOR]
{privilege [,privilege ] ...| all [PRIVILEGES ]}
ON SCHEMA schema-name
FROM {PUBLIC | grantee [,grantee]...} [drop-behavior]
grantee is:
authid
privilege is:
ALTER
| ALTER_TABLE
| CREATE
| CREATE_TABLE
| CREATE_VIEW
| DELETE
| EXECUTE
| INSERT
| UPDATE
| REFERENCES
| SELECT
all is:
ALL
| ALL_DDL
| ALL_DML
drop-behavior is:
{ RESTRICT | CASCADE }
Syntax Description of REVOKE SCHEMA
GRANT OPTION FOR
specifies that the WITH GRANT OPTION for the specified privilege is to be revoked. The
privilege itself is not revoked.
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 DML privilege including DELETE,
EXECUTE, INSERT, REFERENCES, SELECT or UPDATE.
ALL_DDL
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 MAINTAIN.
ALL_DML
Can modify the definition of the objects in the schema.ALTER
Can 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
Can create objects in the schema and become the owner of the objects.CREATE
Can create tables in the schema and be the owner of the table.CREATE_TABLE
Can create regular views in the schema and be the view owner.CREATE_VIEW
REVOKE SCHEMA Statement 141