How to list all user that have permission on database?

How to list all user that have permission on each
database?Mesak,
you need to cycle through all your user databases with
select * -- look up in syslogins and sysusers to see what for columns you
need
from master.dbo.syslogins l
inner join YourDBName.dbo.sysusers u
on l.sid = u.sid
hth
Quentin
"Mesak" <anonymous@.discussions.microsoft.com> wrote in message
news:38e801c4a083$a4ce25f0$a501280a@.phx.gbl...
> How to list all user that have permission on each
> database?