Neoview SQL Reference Manual (R2.3)

Privileges
These privileges are used by the GRANT and REVOKE statements. For further information on
GRANT, see “GRANT Statement” (page 118), “GRANT EXECUTE Statement” (page 120), or
“GRANT SCHEMA Statement” (page 122). For further information on REVOKE, see “REVOKE
Statement” (page 137), “REVOKE EXECUTE Statement” (page 139), or “REVOKE SCHEMA
Statement” (page 141).
object-privilege is:
SELECT
| DELETE
| INSERT
| UPDATE [column-list]
| REFERENCES [column-list]
| EXECUTE
| ALL
column-list is: (column [, column]...)
schema-privilege is:
SELECT
| DELETE
| INSERT
| UPDATE
| REFERENCES
| EXECUTE
| CREATE
| CREATE_TABLE
| CREATE_VIEW
| ALTER
| ALTER_TABLE
| ALL
| ALL_DDL
| ALL_DML
Considerations
General Rules for object-privilege and schema-privilege
• The GRANT commands assign one or more privilege(s) to one or more grantees.
• The REVOKE commands remove one or more privilege(s) from the grantee.
Privilege Descriptions for object-privilege
For tables, materialized views, and views:
• SELECT - Can use SELECT statement.
• DELETE - Can use DELETE statement.
• INSERT - Can use INSERT statement.
• UPDATE - Can use UPDATE statement.
• REFERENCES - Can create constraints that reference the object.
• ALL PRIVILEGES - Can have all privileges (SELECT, DELETE, INSERT, UPDATE, EXECUTE,
and REFERENCES) that apply to the object type.
For schemas:
• SELECT - Can use SELECT statement.
• DELETE - Can use DELETE statement.
• INSERT - Can use INSERT statement.
• UPDATE - Can use UPDATE statement.
• REFERENCES - Can create constraints that reference the object.
• EXECUTE - Can EXECUTE privilege on a schema.
Privileges 255