Displays all active roles.
sp_activeroles [expand_down]
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.
alter role, create role, drop role, grant, revoke, set in Reference Manual: Commands
For information about creating, managing, and using roles, see the System Administration Guide.
mut_excl_roles, proc_role, role_contain, role_name in Reference Manual: Building Blocks
Any user can execute sp_activeroles. Permission checks do not differ based on the granular permissions settings.
Values in event and extrainfo columns from the sysaudits table are:
| Information | Values |
|---|---|
Event | 38 |
Audit option | exec_procedure |
Command or access audited | Execution of a procedure |
Information in extrainfo |
|