Neoview SQL Reference Manual (R2.3)

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_TABLE
| CREATE
| CREATE_TABLE
| CREATE_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, 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 the REFRESH option of MAINTAIN.
ALL_DDL
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_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
Can use DELETE statement.DELETE
Can EXECUTE privilege on a schema.EXECUTE
Can use INSERT statement.INSERT
Can create constraints that reference the schema.REFERENCES
Can use SELECT statement.SELECT
122 SQL Statements