Sybase: get the list of users who have sa_role role

query to logins that have sa_role role:

use master
go
select    suser_name(slr.suid) as 'login',
           ssr.name as 'role'
from      sysloginroles slr,
           syssrvroles ssr
where     ssr.name in ('sa_role')
and       ssr.srid = slr.srid
order by 1,2
go

Show the active roles that current user have:

select show_role()