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

This privilege allows the user to ...

ALTER

Table

Use the ALTER TABLE statement

See Privilege Specification (priv_spec)

CREATEIN

Schema

Create database objects in the specified schema

See Privilege Specification for a Schema (schema_priv_spec)

DELETE

Table

Delete rows in the specified tables

See Privilege Specification (priv_spec)

DROPIN

Schema

Delete database objects in the specified schema

See Privilege Specification for a Schema (schema_priv_spec)

EXECUTE

Database Procedure

Database Function

Execute the database procedure or the database function

See GRANT Statement (grant_statement)

INDEX

Table

Use the CREATE INDEX and DROP INDEX statements

See Privilege Specification (priv_spec)

INSERT

Table

Insert rows in the specified tables

See Privilege Specification (priv_spec)

REFERENCES

Table

Specify the specified table as a referenced table in a column definition or referential CONSTRAINT definition

See Privilege Specification (priv_spec)

SELECT

Sequence

Use the specified sequences

See GRANT Statement (grant_statement)

SELECT

Table or parts of a table

Select entire rows or parts of rows in the specified tables

See Privilege Specification (priv_spec)

SELUPD

Table or parts of a table

The SELECT and UPDATE privileges are granted.

See Privilege Specification (priv_spec)

UPDATE

Table or parts of a table

Change entire rows or parts of rows in the specified tables

See Privilege Specification (priv_spec)

See also:

INSERT-/UPDATE/DELETE Privilege for Owners of View Tables

GRANT Statement

REVOKE Statement

Definition of system tables, ROLEPRIVILEGES, SCHEMAPRIVILEGES, SEQUENCEPRIVILEGES, TABLEPRIVILEGES