Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

To review permissions for a user across all servers, generate the User Permissions

Warning
titleWarning
: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:

  1. Select the Date, Policy, and Baseline options from the Report Settings box.
  2. Select a target SQL Server instance. Otherwise, you can select them all.
  3. Choose the type of Loginthe Level (User or Member).
  4. Select the Object Type from the drop-box.
  5. Select a permission type Permission Type.
  6. Type or browse for the User name.
  7. Choose the Login Type.
  8. Click the View Report button to generate your report.

...