The SYSROLEGRANTS system view is the same as the SYSROLEGRANT system view but includes two additional columns: the name of the role (not just the role ID) and the name of the grantee (not just user ID).
Column name | Data type | Description |
---|---|---|
grant_id | UNSIGNED INT | A unique identifier for each grant statement issued. |
role_id | UNSIGNED INT | The unique identifier for the role granted to a user (as defined in the ISYSUSER table). |
role_name | CHAR(128) | The name of the role corresponding to the role_id value. |
grantee | UNSIGNED INT | The unique identifier for the user granted the role. |
grantee_name | CHAR(128) | The name of the grantee corresponding to the grantee value. |
grant_type | TINYINT | Identifies how the role and its underlying privileges were
granted. Values include:
|
grant_scope | TINYINT | Defines the range to which the grant applies. Values include:
Note: This value is applicable to the SET USER and CHANGE
PASSWORD system privileges only and can store be any valid
combination of these values.
|
grantor | CHAR (128) | The unique identifier of the grantor of the role. |