Audit Tools?

I would like to generate a report detailing permissions of users and groups
per database on my server. What would be the best way to go about doing this
? (I dont want to do this through enterprise manager).
A SQL Script to do this would be PERFECT :)
Thanks,
JustinAre you looking for detailed object & statement permissions for each user or
something simple like the one provided by the system procedure sp_helpuser?
Anith|||ME Too! I'm looking for some way to audit which user has access to which DB
and what Database roles they have. The output of SP_helpuser would work, but
I want it to run against all the databases in a server and save the results
so I can make a report. Other people have got to be interested in such a too
l.
Any help would be appreciated..
"Anith Sen" wrote:

> Are you looking for detailed object & statement permissions for each user
or
> something simple like the one provided by the system procedure sp_helpuser
?
> --
> Anith
>
>