DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.PACKAGEAUTH catalog view

Each row represents a user, group, or role that has been granted one or more privileges on a package.

Table 1. SYSCAT.PACKAGEAUTH 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
PKGSCHEMA VARCHAR (128)   Schema name of the package.
PKGNAME VARCHAR (128)   Unqualified name of the package.
CONTROLAUTH CHAR (1)   CONTROL privilege.
  • N = Not held
  • Y = Held
BINDAUTH CHAR (1)   Privilege to bind the package.
  • G = Held and grantable
  • N = Not held
  • Y = Held
EXECUTEAUTH CHAR (1)   Privilege to execute the package.
  • G = Held and grantable
  • N = Not held
  • Y = Held