Generates a report to map a system privilege to the corresponding system role. A single row is returned for each system privilege.
sp_sys_priv_role_info()
You must have EXECUTE privilege on the system procedure.
Column Name | Data Type | Description |
---|---|---|
sys_priv_name | char(128) | The name of the system privilege |
sys_priv_role_name | char(128) | The role name corresponding to the system privilege. |
sys_priv_id | unsigned int | The id of the system privilege. |