Neoview SQL Reference Manual (R2.2)

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 140).
REVOKE [GRANT OPTION FOR]
{privilege [,privilege ] ...| ALL [PRIVILEGES ]}
ON SCHEMA schema-name
FROM {grantee [,grantee]...} [drop-behavior]
grantee is:
authid | PUBLIC
privilege is:
DELETE
| EXECUTE
| INSERT
| UPDATE
| REFERENCES
| SELECT
drop-behavior is:
RESTRICT
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.
Revokes the DELETE statement.DELETE
Revokes the EXECUTE privilege on a schema.EXECUTE
Revokes the INSERT statement.INSERT
Revokes the UPDATE statement.UPDATE
Can no longer create constraints that reference the
schema.
REFERENCES
Revokes the SELECT statement.SELECT
Revokes all privileges that apply to the schema.ALL PRIVILEGES
ON SCHEMA schema-name
specifies a schema on which to revoke privileges.
FROM {authid [,authid]... | PUBLIC}
specifies one or more roles from whom you revoke privileges.
138 SQL Statements