SYSSEQUENCEAUTH

The SYSSEQUENCEAUTH view contains one row for every privilege granted on a sequence. Note that this catalog view cannot be used to determine whether a user is authorized to a sequence because the privilege to use a sequence could be acquired through a group user profile or special authority (such as *ALLOBJ).

The following table describes the columns in the SYSSEQUENCEAUTH view:

Table 1. SYSSEQUENCEAUTH view
Column Name System Column Name Data Type Description
GRANTOR GRANTOR VARCHAR(128)
Nullable
 Reserved. Contains the null value.
GRANTEE GRANTEE VARCHAR(128) The user profile to which the privilege is granted.
SEQUENCE_SCHEMA SEQSCHEMA VARCHAR(128) Name of the schema
SEQUENCE_NAME SEQNAME VARCHAR(128) Name of the sequence
PRIVILEGE_TYPE PRIVTYPE VARCHAR(10) The privilege granted:
ALTER
The privilege to alter the sequence.
USAGE
The privilege to use the sequence.
IS_GRANTABLE GRANTABLE VARCHAR(3) Indicates whether the privilege is grantable to other users.
NO
The privilege is not grantable.
YES
The privilege is grantable.
AUTHORIZATION_LIST AUTL VARCHAR(10)
Nullable
 If the privilege is granted through an authorization, contains the name of the authorization list.

Contains the null value if the privilege is not granted through an authorization list.
SYSTEM_SEQ_SCHEMA SYSSSCHEMA CHAR(10) System name of the schema
SYSTEM_SEQ_NAME SYSSNAME CHAR(10) System name of the sequence