Neoview SQL Reference Manual (R2.4)

GRANT SCHEMA Statement
• “Syntax Description of GRANT SCHEMA”
• “Considerations for GRANT SCHEMA”
• “Examples of GRANT SCHEMA”
The GRANT SCHEMA statement grants access privileges for a schema to specified roles.
GRANT {privilege [,privilege]... | all [PRIVILEGES] }
ON SCHEMA schema-name
TO {PUBLIC | grantee [,grantee ]... }
[WITH GRANT OPTION]
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
grantee is:
authid
Syntax Description of GRANT SCHEMA
privilege[, privilege]... | all [PRIVILEGES]
specifies the privileges to grant. You can specify each of these privileges for a schema:
Any table, view, or materialized view 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, or materialized view 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
Can modify the definition of the objects in the schema.ALTER
GRANT SCHEMA Statement 137