sp_sys_priv_role_info System Procedure

Generates a report to map a system privilege to the corresponding system role. A single row is returned for each system privilege.

Syntax

sp_sys_priv_role_info()

Result Set

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.

Privileges

none