SQL Reference

SYSCAT.PASSTHRUAUTH

This catalog view contains information about authorizations to query data sources in pass-through sessions. A constraint on the base table requires that the values in SERVER correspond to the values in the SERVER column of SYSCAT.SERVERS. None of the fields in SYSCAT.PASSTHRUAUTH are nullable.


Table 77. Columns in SYSCAT.PASSTHRUAUTH Catalog View
Column Name Data Type Nullable Description
GRANTOR VARCHAR(128)
Authorization ID of the user who granted the privilege.
GRANTEE VARCHAR(128)
Authorization ID of the user or group who holds the privilege.
GRANTEETYPE CHAR(1)
A letter that specifies the type of grantee:

U = Grantee is an individual user.

G = Grantee is a group.

SERVERNAME VARCHAR(128)
Name of the data source that the user or group is being granted authorization to.


[ Top of Page | Previous Page | Next Page ]