Neoview SQL Reference Manual (R2.5)

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. See
“Privileges” (page 301).
GRANT {privilege [,privilege]... | all [PRIVILEGES] }
ON SCHEMA schema-name
TO {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:
CREATE, ALTER, and DROP statements may be performed for any table, view,
materialized view, or procedure in the schema.
ALL_DDL
SELECT, INSERT, UPDATE, DELETE, REFERENCES, and EXECUTE statements may
be performed on any table, view, materialized view, or procedure in the schema.
ALL_DML
Can modify the definition of the objects in the schema.ALTER
140 SQL Statements