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 Date, Policy, and Baseline options from the Report Settings box.
- Select a target instance.
- Choose the type of Login.
- Select a permission type.
- Type or browse for the User name.
- 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.