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. |
...
Follow these steps to create a report:
- Select the Date, Policy, and Baseline options from the Report Settings box.
- Select a target SQL Server instance. Otherwise, you can select them all.
- Choose the type of Login Level (User or Member).
- Select the Object Type from the drop-box.
- Select a permission type Permission Type.
- Type or browse for the User name.
- Choose the Login Type.
- Click the View Report button to generate your report.
Image Added
Note |
---|
|
Consider that the screenshot above was modified. You can find a complete view on SQL Secure console. |
...