Category: ASE: Stored Procedures: Users, Roles und Permissions

sp_activeroles

The system stored procedure sp_activeroles lists all active roles for the current Login in an open session. sp_activeroles can be executed by every user and is located in the system database sybsystemprocs.

Syntax of the Stored Procedure sp_activeroles

sp_activeroles [expand_down]

The parameter expand_down of the Stored Procedure sp_activeroles

Executing the stored procedure sp_activeroles with the parameter expand_down, lists the hierarchy tree of the active roles.

Related commands, functions and stored procedures

• alter role
• create role
• drop role
• grant
• mut_excl_roles()
• proc_role()
• role_contain()
• role_name()
• revoke
• set role
• sp_displayroles

See also:

System Procedures.