list of users with db_datareader privledges

is there a way to select all users who have db_datareader privledges using
sql server code?
tia,
dkTry sp_helpgroup:
Execute sp_helpgroup 'db_datareader'
Or, stealing some code from sp_helpgroup:
select Group_name = substring(g.name, 1, 25), Group_id = g.uid,
Users_in_group = substring(u.name, 1, 25),
Userid = u.uid
from sysusers u, sysusers g, sysmembers m
where g.name = 'db_datareader'
and g.uid = m.groupuid
and (g.issqlrole = 1)
and u.uid = m.memberuid
order by 1, 2
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"dk" <dk@.discussions.microsoft.com> wrote in message
news:5CD3F4A2-4A4E-4FA9-A1F9-2BE81B04CFD2@.microsoft.com...
> is there a way to select all users who have db_datareader privledges using
> sql server code?
> tia,
> dk