Neoview SQL Reference Manual (R2.4)

Privileges
These privileges are used by the GRANT and REVOKE statements. For further information on
GRANT, see “GRANT Statement” (page 133), “GRANT EXECUTE Statement” (page 135), or
“GRANT SCHEMA Statement” (page 137). For further information on REVOKE, see “REVOKE
Statement” (page 154), “REVOKE EXECUTE Statement” (page 156), or “REVOKE SCHEMA
Statement” (page 158).
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
| ALTER
| ALTER_MV
| ALTER_MV_GROUP
| ALTER_SYNONYM
| ALTER_TABLE
| ALTER_TRIGGER
| ALTER_VIEW
| CREATE
| CREATE_MV
| CREATE_MV_GROUP
| CREATE_SYNONYM
| CREATE_TABLE
| CREATE_VIEW
| DROP
| DROP_MV
| DROP_MV_GROUP
| DROP_SYNONYM
| DROP_TABLE
| DROP_TRIGGER
| DROP_VIEW
| 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.
282 SQL Language Elements