Contains one or more rows for each user or group who is granted a privilege
on a particular table or view in the database. All the table privileges
for a single table or view granted by a specific grantor to a specific grantee
appear in a single row.
Table 64. SYSCAT.TABAUTH Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| GRANTOR | CHAR(8) |
| Authorization ID of the user who granted the privileges or SYSIBM. |
| GRANTEE | CHAR(8) |
| Authorization ID of the user or group who holds the privileges. |
| GRANTEETYPE | CHAR(1) |
|
U=Grantee is an individual user G=Grantee is a group |
| TABSCHEMA | CHAR(8) |
| Qualified name of the table or view. |
| TABNAME | VARCHAR(18) |
| |
| CONTROLAUTH | CHAR(1) |
| Indicates whether grantee holds CONTROL privilege on the table or
view:
Y=Privilege is held. N=Privilege is not held. |
| ALTERAUTH | CHAR(1) |
| Indicates whether grantee holds ALTER privilege on the table:
Y=Privilege is held. N=Privilege is not held. G=Privilege is held and grantable. |
| DELETEAUTH | CHAR(1) |
| Indicates whether grantee holds DELETE privilege on the table or
view:
Y=Privilege is held. N=Privilege is not held. G=Privilege is held and grantable. |
| INDEXAUTH | CHAR(1) |
| Indicates whether grantee holds INDEX privilege on the table:
Y=Privilege is held. N=Privilege is not held. G=Privilege is held and grantable. |
| INSERTAUTH | CHAR(1) |
| Indicates whether grantee holds INSERT privilege on the table or
view:
Y=Privilege is held. N=Privilege is not held. G=Privilege is held and grantable. |
| SELECTAUTH | CHAR(1) |
| Indicates whether grantee holds SELECT privilege on the table or
view:
Y=Privilege is held. N=Privilege is not held. G=Privilege is held and grantable. |
| REFAUTH | CHAR(1) |
| Indicates whether grantee holds REFERENCE privilege on the table or
view:
Y=Privilege is held. N=Privilege is not held. G=Privilege is held and grantable. |
| UPDATEAUTH | CHAR(1) |
| Indicates whether grantee holds UPDATE privilege on the table or
view:
Y=Privilege is held. N=Privilege is not held. G=Privilege is held and grantable. |