Contains information about table privileges for each user in the database.

The following table provides details of the SYSTABAUTH table.

Table 1. SYSTABAUTH system table
Column name Column data type Column size
alt VARCHAR 1
AuthMask BIGINT 8
del VARCHAR 1
exe CHAR 1
grantee VARCHAR 32
grantor VARCHAR 32
grantor_domainId INTEGER 4
grantee_domainId INTEGER 4
ins VARCHAR 1
ndx VARCHAR 1
ref VARCHAR 1
sel VARCHAR 1
tbl VARCHAR 32
tblowner VARCHAR 32
upd VARCHAR 1
Dump CHAR 1
Load CHAR 1
SnapShotVer INTEGER 4