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?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment