Versions Compared

Key

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

Description: Show The System Administrator Vulnerability show all SQL Server instances that include Built-in Administrators as members of the sysadmin role.

Warning
titleWarning
Note
Note:This report is does not applicable apply to Azure SQL Database instances. (In Amazon RDS instances, it allows for assigning SYSADMIN rights.
Tip
titleRecommendation

Since assigning the sysadmin role to Windows system administrator (BUILTIN/ADMINISTRATORS) represents an elevated security risk, limit the access to the sysadmin role to database administrators.

Getting Started

: Follow these steps to create a generate the report:

  1. Select the Date, Policy, and Baseline options from the Report Settings box.
  2. Click the “View Report” button View Report button to generate your report.

    Image Added
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