SYSCAT.VARIABLEAUTH catalog view
Each row represents a user, group, or role that has been granted one or more privileges by a specific grantor on a global variable in the database that is not defined in a module.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
GRANTOR | VARCHAR (128) | Grantor of the privilege. | |
GRANTORTYPE | CHAR (1) |
|
|
GRANTEE | VARCHAR (128) | Holder of the privilege. | |
GRANTEETYPE | CHAR (1) |
|
|
VARSCHEMA | VARCHAR (128) | Schema name of the global variable if VARMODULEID is null; otherwise schema name of the module to which the global variable belongs. | |
VARNAME | VARCHAR (128) | Unqualified name of the global variable. | |
VARID | INTEGER | Identifier for the global variable. | |
READAUTH | CHAR (1) | Privilege to read the global variable.
|
|
WRITEAUTH | CHAR (1) | Privilege to write the global variable.
|