sp_sys_priv_role_info( ) 
 

sp_sys_priv_role_info reports the complete one-to-one mapping between system privileges and system roles and role IDs. This procedure returns a row for each system privilege.

Designed mainly for internal use, this procedure is used by utilities that need to map a granted system role to the corresponding system privilege and vice versa.

None

• Roles
• sp_has_role system procedure
• sp_proc_priv system procedure
• sp_displayroles system procedure
• sp_objectpermission system procedure

The following statement returns the mapping of system privileges to their corresponding system role.

CALL sp_sys_priv_role_info();