Neoview SQL Reference Manual (R2.4)

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 161).
REVOKE [GRANT OPTION FOR]
{privilege [,privilege ] ...| all [PRIVILEGES ]}
ON SCHEMA schema-name
FROM {PUBLIC | grantee [,grantee]...} [drop-behavior]
grantee is:
authid
privilege is:
EXECUTE
| DELETE
| INSERT
| UPDATE
| REFERENCES
| SELECT
| ALTER
| ALTER_MV
| ALTER_MV_GROUP
| ALTER_SYNONYM
| ALTER_TABLE
| ALTER_TRIGGER
| ALTER_VIEW
| CREATE
| CREATE_MV
| CREATE_MV_GROUP
| CREATE_PROCEDURE
| CREATE_SYNONYM
| CREATE_TABLE
| CREATE_TRIGGER
| CREATE_VIEW
| DROP
| DROP_MV
| DROP_MV_GROUP
| DROP_PROCEDURE
| DROP_SYNONYM
| DROP_TABLE
| DROP_TRIGGER
| DROP_VIEW
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.
158 SQL Statements