Contains a row for every privilege held on a package.
Table 78. SYSCAT.PACKAGEAUTH Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| GRANTOR | CHAR(8) |
| 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 |
| PKGSCHEMA | CHAR(8) |
| Name of the package on which the privileges are held. |
| PKGNAME | CHAR(8) |
| |
| CONTROLAUTH | CHAR(1) |
| Indicates whether grantee holds CONTROL privilege on the package:
Y=Privilege is held. N=Privilege is not held. |
| BINDAUTH | CHAR(1) |
| Indicates whether grantee holds BIND privilege on the package:
Y=Privilege is held. N=Privilege is not held. |
| EXECUTEAUTH | CHAR(1) |
| Indicates whether grantee holds EXECUTE privilege on the package:
Y=Privilege is held. N=Privilege is not held. |