The HSSYSDAU table is used for SYSDBAUTH views. The following table describes the columns in the HSSYSDAU table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| GRANTOR | CHAR | 128 | 0 | Authorization ID of the user who granted the privileges |
| GRANTEE | CHAR | 128 | 0 | Application ID of the user who holds the privilege |
| NAME | VARCHAR | 24 | 0 | Database name |
| TIMESTAMP | CHAR | 12 | 0 | |
| DATEGRANTED | CHAR | 6 | 0 | |
| TIMEGRANTED | CHAR | 8 | 0 | |
| GRANTEETYPE | CHAR | 1 | 0 | Indicates the type of grantee |
| AUTHHOWGOT | CHAR | 1 | 0 | Authorization level of the user from whom the privileges were received |
| CREATETABAUTH | CHAR | 1 | 0 | Whether the GRANTEE can create tables within the database |
| CREATETSAUTH | CHAR | 1 | 0 | Whether the GRANTEE can create table spaces within the database |
| DBADMAUTH | CHAR | 1 | 0 | Whether the GRANTEE has DBADM authority over the database |
| DBCTRLAUTH | CHAR | 1 | 0 | Whether the GRANTEE has DBCTRL authority over the database |
| DBMAINTAUTH | CHAR | 1 | 0 | Whether the GRANTEE has DBMAINT authority over the database |
| DISPLAYDBAUTH | CHAR | 1 | 0 | Whether the GRANTEE can issue the DISPLAY command for the database |
| DROPAUTH | CHAR | 1 | 0 | Whether the GRANTEE can issue the ALTER DATABASE and DROP DATABASE statement |
| IMAGCOPYAUTH | CHAR | 1 | 0 | Whether the GRANTEE can use the COPY, MERGECOPY, MODIFY, and QUIESCE utilities on the database |
| LOADAUTH | CHAR | 1 | 0 | Whether the GRANTEE can use the LOAD utility to load tables in the database |
| REORGAUTH | CHAR | 1 | 0 | Whether the GRANTEE can use the REORG utility to reorganize table spaces and indexes in the database |
| RECOVERDBAUTH | CHAR | 1 | 0 | Whether the GRANTEE can use the RECOVER and REPORT utilities on table spaces in the database |
| REPAIRAUTH | CHAR | 1 | 0 | Whether the GRANTEE can use the DIAGNOSE and REPAIR utilities on table spaces and indexes in the Database |
| STARTDBAUTH | CHAR | 1 | 0 | Whether the GRANTEE can use the START command against the database |
| STATSAUTH | CHAR | 1 | 0 | Whether the GRANTEE can use the CHECK and RUNSTATS utilities against the database |
| STOPAUTH | CHAR | 1 | 0 | Whether the GRANTEE can issue the STOP command against the database |
| IBMREQD | CHAR | 1 | 0 | |
| GRANTEDTS | TIMESTAMP | 26 | 0 | Time when the GRANT statement was executed |