Neoview SQL Reference Manual (R2.2)

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 {grantee [,grantee ]... }
[WITH GRANT OPTION]
privilege is:
EXECUTE
| DELETE
| INSERT
| UPDATE
| REFERENCES
| SELECT
grantee is:
authid | PUBLIC
Syntax Description of GRANT SCHEMA
privilege[, privilege]... | ALL [PRIVILEGES]
specifies the privileges to grant. You can specify each of these privileges for a schema
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
Can use UPDATE statement.UPDATE
All of the privileges above. Can have all privileges that apply to the object type.ALL PRIVILEGES
ON SCHEMA schema-name
specifies a schema on which to grant privileges.
TO {grantee [,grantee]... }
specifies one or more roles to whom you grant privileges.
grantee specifies an authorization ID to whom you grant privileges. Authorization IDs
identify roles during the processing of SQL statements. The authorization ID must be a valid
role name, enclosed in double quotes. grantee is not case-sensitive.
SQL:1999 specifies two special authorization IDs: PUBLIC and SYSTEM.
• PUBLIC specifies all present and future authorization IDs.
• SYSTEM specifies the implicit grantor of privileges to the creators of objects.
You cannot specify SYSTEM as an authid in a GRANT statement.
WITH GRANT OPTION
specifies that roles to whom privileges are granted have the right to grant the same privilege
to other roles.
GRANT SCHEMA Statement 119