The All User Permissions report allows you to review all objects with permissions in databases for all servers.
Warning
This report can take significant time to generate and may heavily use your system resources. Consider running it from Microsoft Reporting Services instead.
Getting Started
Follow these steps to create a report:
- Select the Date, Policy, and Baseline options from the Report Settings box.
- Select a SQL Server instance. Otherwise, you can select them all.
- Choose the Level (User or Member).
- Select the Object Type from the drop-box.
- Select a Permission Type.
- Type or browse for the User name.
- Choose the Login Type.
- Click the View Report button to generate your report.
You can collapse or expand each option for the available Databases.