This is a custom report developed to list user permissions.
Often DBA's need a consolidated list of permissions for a user, this custom report does this. Developed by Tom Reeves.
Here's a report you can use to see permissions for a given user or role in SQL2005.
Save the attached file to the following location. This is where custom reports have to reside for them to work. Where you see "{user}" should be changed to whatever your username is.
C:\Documents and Settings\{user}\My Documents\SQL Server Management Studio\Custom Reports
User_Permissions.txt - Right click and save with a RDL Extension. (37.25 KB)
