Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  SQL Server Login permissions report

Author  Topic  arnie Starting Member 1 Post Posted - 2007-02-08 : 02:10:46 I need to do a security audit on our SQL servers and need to list all the logins and what permissions they have on which objects. E.g. Read, Execute, Modify etc. Since there are 100's of logins, I don't feel like doing this manually. Can anyone help me with a SQL query or even better yet, a Reporting Services report to produce such a report? Discuss IT Service Management at http://www.itilforums.com