SYSROLEAUTH

The sysroleauth system catalog table describes the roles that are granted to users. It contains one row for each role that is granted to a user in the database. The sysroleauth table has the following columns.
Table 1. SYSROLEAUTH table column descriptions
Column Type Explanation
rolename VARCHAR(32) Name of the role
grantee VARCHAR(32) Name of the grantee of the role
is_grantable CHAR(1) Specifies whether the role is grantable:
  • Y = Grantable
  • N = Not grantable

The is_grantable column indicates whether the role was granted with the WITH GRANT OPTION of the GRANT statement.

A composite index on the rolename and grantee columns allows only unique values.