HSSYSDAU

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