Neoview SQL Reference Manual (R2.4 SP2)

Privileges
These privileges are used by the GRANT and REVOKE statements. For further information on
GRANT, see “GRANT Statement” (page 135), “GRANT EXECUTE Statement” (page 137), or
“GRANT SCHEMA Statement” (page 139). For further information on REVOKE, see “REVOKE
Statement” (page 155), “REVOKE EXECUTE Statement” (page 157), or “REVOKE SCHEMA
Statement” (page 159).
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_PROCEDURE
| CREATE_SYNONYM
| CREATE_TABLE
| CREATE_VIEW
| DROP
| DROP_MV
| DROP_MV_GROUP
| DROP_PROCEDURE
| 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 grantees.
Privilege Descriptions for object-privilege
For tables, materialized views, and views:
• SELECT - Can use SELECT statement.
• DELETE - Can use DELETE statement.
288 SQL Language Elements