Privileges: Overview
There are a number of privileges that can be used to assign the authorizations for data manipulation or data queries for database objects to a database user.
Privilege |
Object |
Privilege Allows Database Users to |
|---|---|---|
|
Table |
Use the More information: Privilege Specification (priv_spec) |
|
Schema |
Create database objects in the specified schema More information: Privilege Specification for a Schema (schema_priv_spec) |
|
Table |
Delete rows in the specified tables More information: Privilege Specification (priv_spec) |
|
Schema |
Delete database objects in the specified schema More information: Privilege Specification for a Schema (schema_priv_spec) |
|
Database procedure Database function |
Execute the database procedure or the database function More information: GRANT Statement (grant_statement) |
|
Table |
Use the More information: Privilege Specification (priv_spec) |
|
Table |
Insert rows in the specified tables More information: Privilege Specification (priv_spec) |
|
Table |
Specify the specified table as a referenced table in a column definition
or referential More information: Privilege Specification (priv_spec) |
|
Sequence |
Use the specified sequences More information: GRANT Statement (grant_statement) |
|
Table or parts of a table |
Select entire rows or parts of rows in the specified tables More information: Privilege Specification (priv_spec) |
|
Table or parts of a table |
The More information: Privilege Specification (priv_spec) |
|
Table or parts of a table |
Change entire rows or parts of rows in the specified tables More information: Privilege Specification (priv_spec) |
INSERT/UPDATE/DELETE Privilege for Owners of View Tables
Definitions of the System Tables, DOMAIN.ROLEPRIVILEGES, DOMAIN.SCHEMAPRIVILEGES, DOMAIN.SEQUENCEPRIVILEGES, DOMAIN.TABLEPRIVILEGES