SYSCAT.MODULEAUTH catalog view

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

Table 1. SYSCAT.MODULEAUTH Catalog View
Column Name Data Type Nullable Description
GRANTOR VARCHAR (128)   Grantor of a privilege
GRANTORTYPE CHAR (1)  
  • S = Grantor is the system
  • U = Grantor is an individual user
GRANTEE VARCHAR (128)   Holder of a privilege.
GRANTEETYPE CHAR (1)  
  • G = Grantee is a group
  • R = Grantee is a role
  • U = Grantee is an individual user
MODULEID INTEGER   Identifier for the module to which this privilege applies.
MODULESCHEMA VARCHAR (128)   Schema name of the module to which this privilege applies.
MODULENAME VARCHAR (128)   Unqualified name of the module to which this privilege applies.
EXECUTEAUTH CHAR (1)   Privilege to execute objects in the identified module.
  • G = Held and grantable
  • N = Not held
  • Y = Held