Description: Records CREATE IN and PACKADM ON privileges for collections; USAGE privileges for distinct types; and USE privileges for buffer pools, storage groups, and table spaces.
Tablespace: SYSGPAUT
Indexes(Fields):
DSNAGH01(GRANTEE.QUALIFIER.NAME.OBTYPE)
| Column name | Description | Data type |
|---|---|---|
| GRANTOR | Authorization ID of the user who granted the privilege. | NOT NULL |
| GRANTEE | Authorization ID of the user who holds the privilege. Could also be PUBLIC for a grant to PUBLIC. | NOT NULL |
| QUALIFIER | Qualifier of the table space (the database name) if the privilege is for a table space (OBTYPE='R'). The schema name of the distinct type if the privilege is for a distinct type (OBTYPE='D'). The schema name of the JAR if the privilege is for a JAR (OBTYPE='J'). The value is PACKADM if the privilege is for a collection (OBTYPE='C') and the authority held is PACKADM. Otherwise, the value is blank. | NOT NULL |
| NAME | Name of the buffer pool, collection, DB2 storage group, distinct type, or table space. Could also be ALL when USE OF ALL BUFFERPOOLS is granted. | NOT NULL |
| Internal use only | 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. ; blank
|
NOT NULL |
| OBTYPE | Type of object: ; B
|
NOT NULL |
| Internal use only | NOT NULL | |
| Not used | NOT NULL | |
| Not used | NOT NULL | |
| USEAUTH | Whether the privilege is held with the GRANT option: ; G
The authority held is PACKADM when the OBTYPE is C (a collection) and QUALIFIER is PACKADM. The authority held is CREATE IN when the OBTYPE is C and QUALIFIER is blank. |
NOT NULL |
| IBMREQD | A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. | NOT NULL |
| GRANTEDTS | Time when the GRANT statement was executed. | NOT NULL WITH DEFAULT |
Adapted from material found in the IBM DB2 Universal Database for z/OS V8 SQL Reference (SC18-7426-02).