DB2 Version 9.7 for Linux, UNIX, and Windows

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)  
  • 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