| Nome da coluna |
Tipo do dado |
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 or the name of a plan or
package that uses the privilege. Can also be PUBLIC for a grant to PUBLIC. |
G |
| SCHEMA |
CHAR(8) NOT NULL |
Schema of the routine |
G |
| SPECIFICNAME |
CHAR(18) NOT NULL |
Specific name of the routine. An asterisk (*) if the privilege is held on all routines
in the schema. |
G |
| GRANTEDTS |
TIMESTAMP NOT NULL |
Time when the GRANT statement was executed. |
G |
| ROUTINETYPE |
CHAR(1) NOT NULL |
Type of routine:
F User-defined function or cast function
P Stored procedure |
G |
| GRANTEETYPE |
CHAR(1) NOT NULL |
Type of grantee:
blank An authorization ID
P
An application plan or package. The grantee is a package if COLLID is not
blank.
R Internal use only |
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.
blank Not applicable
1
Grantor had privilege on schema.* at time of grant
L SYSCTRL
S SYSADM |
G |
| EXECUTEAUTH |
CHAR(1) NOT NULL |
Whether GRANTEE can execute the routine:
Y Privilege is held without GRANT option.
G Privilege is held with GRANT option. |
G |
| COLLID |
CHAR(18) NOT NULL |
If the GRANTEE is a package, its collection name. Otherwise, the value is blank. |
G |
| CONTOKEN |
CHAR(8) NOT NULL |
If the GRANTEE is a package, the consistency token of the DBRM from which the
package was derived. Otherwise, the value is blank. |
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 |
