DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.XSROBJECTAUTH catalog view

Each row represents a user, group, or role that has been granted the USAGE privilege on a particular XSR object.

Table 1. SYSCAT.XSROBJECTAUTH 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
OBJECTID BIGINT   Identifier for the XSR object.
USAGEAUTH CHAR (1)   Privilege to use the XSR object and its components.
  • N = Not held
  • Y = Held