SYSCAT.WORKLOADAUTH catalog view

Each row represents a user, group, or role that has been granted USAGE privilege on a workload.

Table 1. SYSCAT.WORKLOADAUTH Catalog View
Column Name Data Type Nullable Description
WORKLOADID INTEGER   Identifier for the workload.
WORKLOADNAME VARCHAR (128)   Name of the workload.
GRANTOR VARCHAR (128)   Grantor of the privilege.
GRANTORTYPE CHAR (1)  
  • S = Grantor is the system
  • U = Grantee 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
USAGEAUTH CHAR (1)   Indicates whether grantee holds USAGE privilege on the workload.
  • N = Not held
  • Y = Held
GRANT_TIME TIMESTAMP   Time at which the privilege was granted.