The HSSYTAU table is used for SYSTABAUTH views. The following table describes the columns in the HSSYSTAU table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| GRANTOR | VARCHAR | 128 | 0 | Authorization ID or role of the user who granted the privileges |
| GRANTEE | VARCHAR | 128 | 0 | Authorization ID of the user who holds the privileges or the name of an application plan or package that uses the privileges |
| GRANTEETYPE | CHAR | 1 | 0 | Type of grantee |
| DBNAME | VARCHAR | 24 | 0 | If the privileges were received from a user with DBADM, DBCTRL, or DBMAINT authority, DBNAME is the name of the database on which the GRANTOR has that Authority |
| SCREATOR | VARCHAR | 128 | 0 | If the row of SYSIBM.SYSTABAUTH was created as a result of a CREATE VIEW statement, SCREATOR is the schema of a table or view referred to in the CREATE VIEW statement |
| STNAME | VARCHAR | 128 | 0 | the name of a table or view referred to in the fullselect of the CREATE TABLE statement |
| TCREATOR | VARCHAR | 128 | 0 | The schema of the table or view |
| TTNAME | VARCHAR1 | 128 | 0 | Name of the table or view |
| AUTHHOWGOT | CHAR | 1 | 0 | Authorization level of the user from whom the privileges were received |
| TIMESTAMP | CHAR | 12 | 0 | |
| DATEGRANTED | CHAR | 6 | 0 | |
| TIMEGRANTED | CHAR | 8 | 0 | |
| UPDATECOLS | CHAR | 1 | 0 | The value is blank if the value of UPDATEAUTH applies uniformly to all columns of the table or view. The value is an asterisk (*) if the value of UPDATEAUTH applies to some columns but not to others. In this case, rows will exist in SYSIBM.SYSCOLAUTH with matching timestamps and PRIVILEGE = blank. These rows list the columns on which update privileges have been granted. |
| ALTERAUTH | CHAR | 1 | 0 | Whether the GRANTEE can alter the table |
| DELETEAUTH | CHAR | 1 | 0 | Whether the GRANTEE can delete rows from the table or view |
| INDEXAUTH | CHAR | 1 | 0 | Whether the GRANTEE can create indexes on the table |
| INSERTAUTH | CHAR | 1 | 0 | Whether the GRANTEE can insert rows into the table or view |
| SELECTAUTH | CHAR | 1 | 0 | Whether the GRANTEE can select rows from the table or view |
| UPDATEAUTH | CHAR | 1 | 0 | Whether the GRANTEE can update rows of the table or view |
| IBMREQD | CHAR | 1 | 0 | |
| GRANTEELOCATION | VARCHAR | 128 | 0 | |
| LOCATION | VARCHAR | 128 | 0 | |
| COLLID | VARCHAR | 128 | 0 | If the GRANTEE is a package, its collection name. Otherwise, the value is blank |
| CONTOKEN | CHAR | 8 | 0 | If the GRANTEE is a package, the consistency token of the DBRM from which the package was derived. Otherwise, the value is blank |
| CAPTUREAUTH | CHAR | 1 | 0 | |
| REFERENCESAUTH | CHAR | 1 | 0 | Whether the GRANTEE can create or drop referential constraints in which the table is a parent |
| REFCOLS | CHAR | 1 | 0 | The value of this column is blank if the value of REFERENCESAUTH applies uniformly to all columns of the table. The value is an asterisk(*) if the value of REFERENCESAUTH applies to some columns but not to others. In this case, rows will exist in SYSIBM.SYSCOLAUTH with PRIVILEGE = R and matching timestamps that list the columns on which reference privileges have been granted |
| GRANTEDTS | TIMESTAMP | 26 | 0 | Time when the GRANT statement was executed |
| TRIGGERAUTH | CHAR | 1 | 0 | Whether the GRANTEE can create triggers in which the table is named as the subject table |