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 Login 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.

Image Added

Note
titleNote

Consider that the screenshot above was modified. You can find a complete view on SQL Secure console.

Scroll pdf ignore
Excerpt

Newtabfooter
aliasIDERA
urlhttp://www.idera.com
|
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.

...

secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse