SYSSEQUENCEAUTH catalog table
The SYSSEQUENCEAUTH table records the privileges that are held by users over sequences. The schema is SYSIBM.
Column name | Data type | Description | Use |
---|---|---|---|
GRANTOR | VARCHAR(128)
NOT NULL |
Authorization ID of the user who granted the privileges. | G |
GRANTEE | VARCHAR(128)
NOT NULL |
Authorization ID of the user or group that holds the privileges or the name of an application plan or package that uses the privileges. PUBLIC for a grant to PUBLIC. | G |
SCHEMA | VARCHAR(128)
NOT NULL |
Schema of the sequence. | G |
NAME | VARCHAR(128)
NOT NULL |
Name of the sequence. | G |
GRANTEETYPE | CHAR(1)
NOT NULL |
Type of grantee:
|
G |
AUTHHOWGOT | CHAR(1)
NOT NULL |
Authorization level of the user from whom the privileges
were received. This authorization level is not necessarily the highest
authorization level of the grantor:
|
G |
ALTERAUTH | CHAR(1)
NOT NULL |
Indicates whether grantee holds ALTER privilege
on the sequence:
|
G |
USEAUTH | CHAR(1)
NOT NULL |
Indicates whether grantee holds USAGE privilege
on the sequence:
|
G |
COLLID | VARCHAR(128)
NOT NULL |
If the GRANTEE is a package, its collection name. Otherwise, a string of length zero. | G |
CONTOKEN | CHAR(8)
NOT NULL FOR BIT DATA |
If the GRANTEE is a package, the consistency token of the DBRM from which the package was derived. Otherwise, blank. | G |
GRANTEDTS | TIMESTAMP
NOT NULL |
Time when the GRANT statement was executed. | G |
IBMREQD | CHAR(1)
NOT NULL |
A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators. The value in this field is not a reliable indicator of release dependencies. |
G |
GRANTORTYPE | CHAR(1)
NOT NULL WITH DEFAULT |
Indicates the type of grantor:
|
G |
SYS_START | TIMESTAMP(12)
NOT NULL GENERATED ALWAYS AS ROW BEGIN |
Reserved for future IBM® use.The row-begin column of the SYSTEM_TIME period, for system-period data versioning. | G |
SYS_END | TIMESTAMP(12)
NOT NULL GENERATED ALWAYS AS ROW END |
Reserved for future IBM use.The row-end column of the SYSTEM_TIME period, for system-period data versioning. | G |
TRANS_START | TIMESTAMP(12)
NOT NULL GENERATED ALWAYS AS TRANSACTION START ID |
Reserved for future IBM use. | G |