The HSSYSRAU table is used for SYSRESAUTH views. The following table describes the columns in the HSSYSRAU table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| GRANTOR | VARCHAR | 128 | 0 | Authorization ID of the user who granted the privilege |
| GRANTEE | VARCHAR | 128 | 0 | Authorization ID of the user who holds the privilege |
| QUALIFIER | VARCHAR | 128 | 0 | Qualifier of the table space |
| NAME | VARCHAR | 128 | 0 | Name of the buffer pool |
| GRANTEETYPE | CHAR | 1 | 0 | |
| AUTHHOWGOT | CHAR | 1 | 0 | Authorization level of the user from whom the privileges were received |
| OBTYPE | CHAR | 1 | 0 | Type of object |
| TIMESTAMP | CHAR | 12 | 0 | |
| DATEGRANTED | CHAR | 8 | 0 | |
| TIMEGRANTED | CHAR | 8 | 0 | |
| USEAUTH | CHAR | 1 | 0 | Whether the privilege is held with the GRANT option |
| IBMREQD | CHAR | 1 | 0 | |
| GRANTEDTS | TIMESTAMP | 26 | 0 | Time when the GRANT statement was executed |