A tabela SYSVARIABLEAUTH contém uma linha para cada privilégio de cada ID de autorização que possui privilégios em uma variável global.
O esquema é SYSIBM.
The SYSVARIABLEAUTH table contains one row for each privilege of each authorization ID that has privileges on a global variable.
The schema is SYSIBM.
| Column name |
Data type |
Description |
Use |
| GRANTOR |
VARCHAR(128)
NOT NULL |
The grantor of the privilege. |
G |
| GRANTORTYPE |
CHAR(1)
NOT NULL |
The type of grantor:
- blank
- Grantor is an authorization ID
- L
- Grantor is a role
|
G |
| GRANTEE |
VARCHAR(128)
NOT NULL |
The holder of the privilege. |
G |
| GRANTEETYPE |
CHAR(1)
NOT NULL |
The type of grantee:
- blank
- Grantee is an authorization ID
- L
- Grantee is a role
- P
- Grantee is a package.
The grantee is a package if COLLID is a value other than blank.
|
G |
| SCHEMA |
VARCHAR(128)
NOT NULL |
The schema name of the global variable. |
G |
| NAME |
VARCHAR(128)
NOT NULL |
The unqualified name of the global variable. |
G |
| COLLID |
VARCHAR(128)
NOT NULL |
If the grantee is a package, this value is the COLLID of the package. |
G |
| CONTOKEN |
CHAR(8)
NOT NULL
FOR BIT DATA |
If the grantee is a package, this value is the consistency token of the DBRM from which the package is derived.
Otherwise, this value is blank. |
G |
| READAUTH |
CHAR(1)
NOT NULL |
The privilege to read the global variable:
- blank
- The READ privilege is not held
- G
- The READ privilege is held with the GRANT option
- Y
- The READ privilege is held without the GRANT option
|
G |
| WRITEAUTH |
CHAR(1)
NOT NULL |
The privilege to write to the global variable:
- blank
- The WRITE privilege is not held
- G
- The WRITE privilege is held with the GRANT option
- Y
- The WRITE privilege is held without the GRANT option
|
G |
| AUTHHOWGOT |
CHAR(1)
NOT NULL |
The authorization level of the user who granted the privileges:
- blank
- Not applicable
- E
- SECADM
- G
- ACCESSCTRL
- S
- SYSADM
- T
- DATAACCESS
This authorization level is not necessarily the highest authority level of the grantor. |
G |
| GRANTEDTS |
TIMESTAMP
NOT NULL |
The 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.
The value in this field is not a reliable indicator of release dependencies. |
G |
