command to show users of a role

tiger66 · #1 (**permalink**) 12-31-08, 20:19

Hi
I am just wondering if there is any sybase command to show the name of the users that a role has?

I have a role "SUPPORT" and I want to know what users have been assigned to that role

Thanks in advance for your help

Martijnvs · #2 (**permalink**) 01-05-09, 05:31

There is no specific command, but you can use this query:

Code:

select sr.name, sl.name
from syssrvroles sr, syslogins sl, sysloginroles slr
where sl.suid = slr.suid
and sr.srid = slr.srid
and sr.name like "sa_role"

In the last line, you can substitute sa_role with any role-name you want to know the members of.