Records the database authorities held by users.
Table 44. SYSCAT.DBAUTH Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| GRANTOR | CHAR(8) |
| SYSIBM or authorization ID of the user who granted the privileges. |
| 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 |
| DBADMAUTH | CHAR(1) |
| Whether grantee holds DBADM authority over the database:
Y=Authority is held N=Authority is not held |
| CREATETABAUTH | CHAR(1) |
| Whether grantee can create tables in the database (CREATETAB):
Y=Privilege is held N=Privilege is not held |
| BINDADDAUTH | CHAR(1) |
| Whether grantee can create new packages in the database (BINDADD):
Y=Privilege is held N=Privilege is not held |
| CONNECTAUTH | CHAR(1) |
| Whether grantee can connect to the database (CONNECT):
Y=Privilege is held N=Privilege is not held |
| NOFENCEAUTH | CHAR(1) |
| Whether grantee holds privilege to create non-fenced functions.
Y=Privilege is held N=Privilege is not held |
| IMPLSCHEMAAUTH | CHAR(1) |
| Whether grantee can implicitly create schemas in the database
(IMPLICIT_SCHEMA):
Y=Privilege is held N=Privilege is not held |