Neoview SQL Reference Manual (R2.5)

Privileges
These privileges are used by the GRANT and REVOKE statements. For further information on
GRANT, see “GRANT Statement” (page 136), “GRANT EXECUTE Statement” (page 138), or
“GRANT SCHEMA Statement” (page 140). For further information on REVOKE, see “REVOKE
Statement” (page 156), “REVOKE EXECUTE Statement” (page 158), or “REVOKE SCHEMA
Statement” (page 160).
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.
Privileges 301