Description: Records the privileges that are held by users over sequences.
Tablespace: SYSSEQ2
Indexes(Fields):
DSNWCX01(SCHEMA.NAME)
DSNWCX02(GRANTOR.SCHEMA.NAME)
DSNWCX03(GRANTEE.SCHEMA.NAME)
| Column name | Description | Data type |
|---|---|---|
| GRANTOR | Authorization ID of the user who granted the privileges. | NOT NULL |
| GRANTEE | 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. | NOT NULL |
| SCHEMA | Schema of the sequence. | NOT NULL |
| NAME | Name of the sequence. | NOT NULL |
| GRANTEETYPE | Type of grantee: ; blank
|
NOT NULL |
| AUTHHOWGOT | Authorization level of the user from whom the privileges were received. This authorization level is not necessarily the highest authorization level of the grantor: ; L
|
NOT NULL |
| ALTERAUTH | Indicates whether grantee holds ALTER privilege on the sequence: ; blank
|
NOT NULL |
| USEAUTH | Indicates whether grantee holds USAGE privilege on the sequence: ; blank
|
NOT NULL |
| COLLID | If the GRANTEE is a package, its collection name. Otherwise, a string of length zero. | NOT NULL |
| CONTOKEN | If the GRANTEE is a package, the consistency token of the DBRM from which the package was derived. Otherwise, blank. | NOT NULL FOR BIT DATA |
| GRANTEDTS | Time when the GRANT statement was executed. | NOT NULL |
| IBMREQD | A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. | NOT NULL |
Adapted from material found in the IBM DB2 Universal Database for z/OS V8 SQL Reference (SC18-7426-02).