| Nome da coluna |
Tipo de dados |
Descrição |
Uso |
| GRANTOR |
CHAR(8) NOT NULL |
Authorization ID of the user who granted the privilege. Could also be
PUBLIC or PUBLIC followed by an asterisk. |
G |
| GRANTEE |
CHAR(8) NOT NULL |
Authorization ID of the user who holds the privileges, the name of a plan
that uses the privileges or PUBLIC for a grant to PUBLIC. |
G |
| LOCATION |
CHAR(16) NOT NULL |
Always contains blanks |
S |
| COLLID |
CHAR(18) NOT NULL |
Collection name for the package or packages on which the privilege was
granted. |
G |
| NAME |
CHAR(8) NOT NULL |
Name of the package on which the privileges are held. An asterisk (*) if
the privileges are held on all packages in a collection. |
G |
| |
CHAR(8) NOT NULL |
Not used |
N |
| TIMESTAMP |
TIMESTAMP NOT NULL |
Timestamp indicating when the privilege was granted. |
G |
| GRANTEETYPE |
CHAR(1) NOT NULL |
Type of grantee:
blank Authorization ID
P Application plan |
G |
| AUTHHOWGOT |
CHAR(1) NOT NULL |
Authorization level of the user from whom the privileges were received.
This authorization level is not necessarily the highest authorization level
of the grantor.
blank Not applicable
A PACKADM (on collection *)
C DBCTL
D DBADM
L SYSCTRL
M DBMAINT
P PACKADM (on a specific collection)
S SYSADM |
G |
| BINDAUTH |
CHAR(1) NOT NULL |
Whether GRANTEE can use the BIND and REBIND subcommands against
the package:
blank Privilege is not held
G Privilege is held with the GRANT option
Y Privilege is held withou the GRANT option |
G |
| COPYAUTH |
CHAR(1) NOT NULL |
Whether GRANTEE can COPY the package:
blank Privilege is not held
G Privilege is held with the GRANT option
Y Privilege is held withou the GRANT option |
G |
| EXECUTEAUTH |
CHAR(1) NOT NULL |
Whether GRANTEE can execute the package:
blank Privilege is not held
G Privilege is held with the GRANT option
Y Privilege is held withou the GRANT option |
G |
| IBMREQD |
CHAR(1) NOT NULL |
Whether the row came from the basic machine readable material (MRM)
tape:
N No
Y Yes |
G |
