The SYSROLEGRANTEXT system view contains syntax extensions pertaining to the SET USER and CHANGE PASSWORD system privilege and is related to the SYSROLEGRANT system view.
| Column name | Data type | Description |
|---|---|---|
| grant_id | UNSIGNED INT | ID used to identify each GRANT statement. |
| user_id | UNSIGNED INT | The user_ids specified in user-list or role-list in a particular extended grant. |
When you grant or revoke the SET USER or CHANGE PASSWORD privilege, either with the user-list option or with ANY WITH ROLES role-list option, this view is updated with the values from the extended syntax.
PRIMARY KEY (grant_id, user_id)