DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.PASSTHRUAUTH catalog view

Each row represents a user, group, or role that has been granted pass-through authorization to query a data source.

Table 1. SYSCAT.PASSTHRUAUTH 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
SERVERNAME VARCHAR (128)   Name of the data source to which authorization is being granted.