sp_auth_sys_role_info System Procedure

Generates a report which maps authorities to corresponding system roles and role id. This procedure returns a row for each authority.

Syntax

sp_auth_sys_role_info()

Result Set

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.

Privileges

none