| Nome da coluna |
Tipo de dados |
Descrição |
Uso |
| GRANTOR |
CHAR(8) NOT NULL |
Authorization ID of the user who granted the privileges. |
G |
| GRANTEE |
CHAR(8) NOT NULL |
Authorization ID of the user who holds the privileges. Could also be
PUBLIC for a grant to PUBLIC. |
G |
| NAME |
CHAR(8) NOT NULL |
Name of the application plan on which the privileges are held. |
G |
| |
CHAR(12) NOT NULL |
Internal use only |
I |
| DATEGRANTED |
CHAR(6) NOT NULL |
Date the privileges were granted; in the form yymmdd. |
G |
| TIMEGRANTED |
CHAR(8) NOT NULL |
Time the privileges were granted; in the form hhmmssth. |
G |
| |
CHAR(1) NOT NULL |
Not used |
N |
| 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
C DBCTL
D DBADM
L SYSCTRL
M DBMAINT
S SYSADM |
G |
| BINDAUTH |
CHAR(1) NOT NULL |
Whether the GRANTEE can use the BIND, REBIND, or FREE
subcommands against the plan:
blank Privilege is not held
G
Privilege is held with the GRANT option
Y
Privilege is held without the GRANT option |
G |
| EXECUTEAUTH |
CHAR(1) NOT NULL |
Whether the GRANTEE can run application programs that use the application plan:
blank Privilege is not held
G
Privilege is held with the GRANT option
Y
Privilege is held without 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 |
| GRANTEDTS |
TIMESTAMP NOT NULL
WITH DEFAULT |
Time when the GRANT statement was executed. |
G |
