SEQUENCEPRIVILEGES

Definition

The system table SEQUENCEPRIVILEGES describes the privileges that the current user has for sequences or privileges that he has granted for sequences.

Structure

SEQUENCEPRIVILEGES

SCHEMANAME

CHAR(32)

Name of the schema of the sequence

OWNER

CHAR(32)

Name of the owner of the sequence

SEQUENCENAME

CHAR(32)

Name of the sequence

GRANTOR

CHAR(32)

Name of the user who granted the privileges

GRANTEE

CHAR(32)

Name of the user or role to which the privilege was granted

PRIVILEGE

CHAR(30)

Granted privileges

IS_GRANTABLE

CHAR(3)

Privilege to grant the received privilege to another user/role (YES | NO)

See also:

SQL Reference Manual, Sequence Name (sequence_name), Privileges: Overview