Displays all active roles.
sp_activeroles [expand_down]
shows the hierarchy tree of all active roles contained by your roles.
sp_activeroles
Role Name ------------------------------ sa_role sso_role oper_role replication_role
sp_activeroles expand_down
Role Name Parent Role Name Level -------------------------------- ------------------- sa_role NULL 1 doctor_role NULL 1 oper_role NULL 1
sp_activeroles displays all your active roles and all roles contained by those roles.
For information about creating, managing, and using roles, see the System Administration Guide.
Any user can execute sp_activeroles.
Commands alter role, create role, drop role, grant, revoke, set
Functions mut_excl_roles, proc_role, role_contain, role_name
System procedures sp_displayroles
