| Nome da coluna |
Tipo de dados |
Descrição |
Uso |
| GRANTOR |
CHAR(8) NOT NULL |
Authorization ID of the user who granted the privilege. |
G |
| GRANTEE |
CHAR(8) NOT NULL |
Authorization ID of the user who holds the privilege. Could also be
PUBLIC for a grant to PUBLIC. |
G |
| QUALIFIER |
CHAR(8) NOT NULL |
The qualifier of the table space (the database name), if the row
describes a privilege over a table space. Blank otherwise. |
G |
| NAME |
CHAR(18) NOT NULL |
Name of the buffer pool, collection, DB2 storage group, or table space.
Could also be ALL when USE OF ALL BUFFERPOOLS is granted. |
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
P PACKADM (on a specific collection)
A PACKADM (on collection *) |
G |
| OBTYPE |
CHAR(1) NOT NULL |
Object type:
B Buffer pool
C Collection
S Storage group
R Table space |
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 |
| USEAUTH |
CHAR(1) NOT NULL |
Whether the privilege is held with the GRANT option:
G Privilege is held with the GRANT option
Y Privilege is held without the GRANT option
The authority held is PACKADM when the OBTYPE is C (a collection) and
QUALIFIER is PACKADM. The authority held is CREATE IN when the
OBTYPE is C and QUALIFIER is blank. |
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 |
