| Nome da coluna |
Tipo de dado |
Descrição |
Uso |
| GRANTOR |
CHAR(8) NOT NULL |
Authorization ID of the user who granted the privileges. Could also be PUBLIC
or PUBLIC followed by an asterisk |
G |
| GRANTEE |
CHAR(8) NOT NULL |
Authorization ID of the user who holds the privilege or the name of an
application plan or package that uses the privilege. PUBLIC for a grant to
PUBLIC. PUBLIC followed by an asterisk for a grant to PUBLIC AT ALL
LOCATIONS. |
G |
| GRANTEETYPE |
CHAR(1) NOT NULL |
Type of grantee:
blank GRANTEE is an authorization ID
P
GRANTEE is an application plan or a package. It is a package if
COLLID is not blank. |
G |
| CREATOR |
CHAR(8) NOT NULL |
The authorization ID of the owner of the table or view on which the update
privilege is held. |
G |
| TNAME |
VARCHAR(18) NOT NULL |
The name of the table or view. |
G |
| |
CHAR(12) NOT NULL |
Internal use only |
I |
| DATEGRANTED |
CHAR(6) NOT NULL |
Date the privilege was granted, in the form yymmdd. |
G |
| TIMEGRANTED |
CHAR(8) NOT NULL |
Time the privilege was granted, in the form hhmmssth. |
G |
| COLNAME |
VARCHAR(18) NOT NULL |
Name of the column to which the UPDATE privilege applies. |
G |
| IBMREQD |
CHAR(1) NOT NULL |
Whether the row came from the basic machine readable material (MRM) tape:
N No
Y Yes
|
G |
| |
CHAR(16) NOT NULL WITH DEFAULT |
Not used |
N |
| COLLID |
CHAR(18) NOT NULL WITH DEFAULT |
If GRANTEE is a package, its collection name. Otherwise, blank. |
G |
| CONTOKEN |
CHAR(8) NOT NULL WITH DEFAULT |
If GRANTEE is a package, the consistency token of the DBRM from which the
package was derived. Otherwise, blank. |
S |
| PRIVILEGE |
CHAR(1) NOT NULL WITH DEFAULT |
Indicates which privilege this row describes:
R Row pertains to the
REFERENCES privilege.
blank Row pertains to the UPDATE privilege. |
G |
| GRANTEDTS |
TIMESTAMP NOT NULL WITH DEFAULT |
Time when the GRANT statement was executed. |
G |
