Home | Previous Page | Next Page   System Catalog Tables >

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.

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.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]