Background documentationPrivileges: Overview Locate this document in the navigation structure

 

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)