Versions Compared

Key

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

Description: Show The Guest Enabled Databases report shows all databases on a SQL Server instance where the Guest user has access.

Notewarning
Note: This report is does not applicable apply to Azure SQL Database instances. Moreover, for Amazon RDS for SQL Server instances, System Databases and rdsadmin are unavailable.
Tip
titleRecommendation

To guarantee the SQL Server environment security, remove all guest user accounts.

To remove them from production databases, you can use the sp_dropuser command.

Getting Started

Getting Started:Follow these steps to create a reportgenerate the report follow the steps below:

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