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.

Table 1. SYSCAT.VARIABLEAUTH Catalog View
Column Name Data Type Nullable Description
GRANTOR VARCHAR (128)   Grantor of the privilege.
GRANTORTYPE CHAR (1)  
  • S = Grantor is the system
  • U = Grantor is an individual user
GRANTEE VARCHAR (128)   Holder of the privilege.
GRANTEETYPE CHAR (1)  
  • G = Grantee is a group
  • R = Grantee is a role
  • U = Grantee is an individual user
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.
  • G = Held and grantable
  • N = Not held
  • Y = Held
WRITEAUTH CHAR (1)   Privilege to write the global variable.
  • G = Held and grantable
  • N = Not held
  • Y = Held