To review permissions for a user across all servers, generate the User Permissions
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.
Note
Consider that the screenshot above was modified. You can find a complete view on SQL Secure console.