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.
Any user can execute sp_activeroles.
Documents For information about creating, managing, and using roles, see the System Administration Guide.
Commands alter role, create role, drop role, grant, revoke, set
Functions mut_excl_roles, proc_role, role_contain, role_name
System procedures sp_displayroles
