DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.ROLEAUTH catalog view

Each row represents a role granted to a user, group, role, or PUBLIC.

Table 1. SYSCAT.ROLEAUTH Catalog View
Column Name Data Type Nullable Description
GRANTOR VARCHAR (128)   Authorization ID that granted the role.
GRANTORTYPE CHAR (1)  
  • U = Grantor is an individual user
GRANTEE VARCHAR (128)   Authorization ID to which the role was granted.
GRANTEETYPE CHAR (1)  
  • G = The grantee is a group
  • R = The grantee is a role
  • U = The grantee is an individual user
ROLENAME VARCHAR (128)   Name of the role.
ROLEID INTEGER   Identifier for the role.
ADMIN CHAR (1)   Privilege to grant or revoke the role to or from others, or to comment on the role.
  • N = Not held
  • Y = Held