To find all active roles for the current login session of Adaptive Server, use:
sp_activeroles [expand_down]
expand_down displays the hierarchy of all roles contained by any roles granted to you.
Any user can execute sp_activeroles.
