| Nome da coluna |
Tipo do dado |
Descrição |
Uso |
| GRANTOR |
CHAR(8) NOT NULL |
Authorization ID of the user who granted the privileges or SYSADM. |
G |
| GRANTEE |
CHAR(8) NOT NULL |
Authorization ID of the user or group who holds the privileges. Can also be PUBLIC
for a grant to PUBLIC. |
G |
| SCHEMANAME |
CHAR(8) NOT NULL |
Name of the schema or '*' for all schemas. |
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.
This field is also used to indicate that the privilege was held on all schemas by the
grantor.
1
Grantor had privilege on all schemas at time of grant
L SYSCTRL
S SYSADM |
G |
| CREATEINAUTH |
CHAR(1) NOT NULL |
Indicates whether grantee holds CREATEIN privilege on the schema:
blank Privilege is not held
G Privilege is held with the GRANT option
Y Privilege is held without the GRANT option |
G |
| ALTERINAUTH |
CHAR(1) NOT NULL |
Indicates whether grantee holds ALTERIN privilege on the schema:
blank Privilege is not held
G Privilege is held with the GRANT option
Y Privilege is held without the GRANT option |
G |
| DROPINAUTH |
CHAR(1) NOT NULL |
Indicates whether grantee holds DROPIN privilege on the schema:
blank Privilege is not held
G Privilege is held with the GRANT option
Y Privilege is held without the GRANT option |
G |
| GRANTEDTS |
TIMESTAMP NOT NULL |
Time when the GRANT statement was executed. |
G |
| IBMREQD |
CHAR(1) NOT NULL |
A value of Y indicates that the row came from the basic machine-readable material
(MRM) tape. For all other values, see Release dependency indicators in topic D.0. |
G |
