Neoview SQL Reference Manual (R2.2)

Privileges
These privileges are used by the GRANT and REVOKE statements. For further information on
GRANT, see “GRANT Statement” (page 115), “GRANT EXECUTE Statement” (page 117), or
“GRANT SCHEMA Statement” (page 119). For further information on REVOKE, see “REVOKE
Statement” (page 134), “REVOKE EXECUTE Statement” (page 136), or “REVOKE SCHEMA
Statement” (page 138).
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
| DBA
| ALL
AD
The AD privilege is assigned to the schema owner. It cannot be granted or revoked.
Considerations
General Rules for object-privilege and schema-privilege
• The GRANT commands assign one or more privilege(s) to the grantee.
• 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.
• ALL PRIVILEGES - Can have all privileges (SELECT, DELETE, INSERT, UPDATE, EXECUTE,
and REFERENCES) that apply to the object type.
Privileges 245