The SYSROLEGRANT system view contains one row for each grant of a system or user defined role. The underlying system table for this view is ISYSROLEGRANT.
Column name | Data type | Description |
---|---|---|
grant_id | UNSIGNED INT | ID used to identify each GRANT statement. |
role_id | UNSIGNED INT | ID of the role being granted, as per ISYSUSER. |
grantee | UNSIGNED INT | ID of the user being granted the role, as per ISYSUSER. |
grant_type | TINYINT |
Describes type of grant using 3 digits. The first digit is
whether privilege has been granted. The second digit is
whether administration rights have been given. The third
digit is whether system privileges are inheritable.
|
grant_scope | TINYINT |
Used by SET USER and CHANGE PASSWORD to set the scope of the grant. Values can be one or more of the following:
|
grantor | CHAR (128) | The unique identifier of the grantor of the role. |
PRIMARY KEY (grant_ID)
UNIQUE Index (role_id, grantee, grant_scope)