SYSVARIABLEAUTH catalog table

The SYSVARIABLEAUTH table contains one row for each privilege of each authorization ID that has privileges on a global variable. The schema is SYSIBM.

Table 1. SYSIBM.SYSVARIABLEAUTH table column descriptions
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.
Start of changeREnd of change
Start of changeInternal use onlyEnd of change
 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 was provided with the Db2 product code. For all other values, see Release dependency indicators.

The value in this field is not a reliable indicator of release dependencies.

 G