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

Warning

This report does not apply to Azure SQL Database instances. In Amazon RDS instances, it allows assigning SYSADMIN rights.

Recommendation

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 generate the report:

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



IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels