Generates a report which maps authorities to corresponding system roles and role id. This procedure returns a row for each authority.
sp_auth_sys_role_info()
Column Name | Data Type | Description |
---|---|---|
auth | varchar(20) | The name of the authority. |
role_name | char(128) | The name of the equivalent system role. |
role_id | unsigned int | The id of the system role. |
none