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 |
---|---|---|
ALTER |
Table |
Use the ALTER TABLE statement More information: Privilege Specification (priv_spec) |
CREATEIN |
Schema |
Create database objects in the specified schema More information: Privilege Specification for a Schema (schema_priv_spec) |
DELETE |
Table |
Delete rows in the specified tables More information: Privilege Specification (priv_spec) |
DROPIN |
Schema |
Delete database objects in the specified schema More information: Privilege Specification for a Schema (schema_priv_spec) |
EXECUTE |
Database procedure Database function |
Execute the database procedure or the database function More information: GRANT Statement (grant_statement) |
INDEX |
Table |
Use the CREATE INDEX, ALTER INDEX and DROP INDEX statements More information: Privilege Specification (priv_spec) |
INSERT |
Table |
Insert rows in the specified tables More information: Privilege Specification (priv_spec) |
REFERENCES |
Table |
Specify the specified table as a referenced table in a column definition or referential CONSTRAINT definition More information: Privilege Specification (priv_spec) |
SELECT |
Sequence |
Use the specified sequences More information: GRANT Statement (grant_statement) |
SELECT |
Table or parts of a table |
Select entire rows or parts of rows in the specified tables More information: Privilege Specification (priv_spec) |
SELUPD |
Table or parts of a table |
The SELECT and UPDATE privileges are granted. More information: Privilege Specification (priv_spec) |
UPDATE |
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