The system table SEQUENCEPRIVILEGES describes the privileges that the current user has for sequences or privileges that he has granted for sequences.
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