Versions Compared

Old Version 1

changes.mady.by.user Horacio Sanjines

Saved on

compared with

New Version Current

changes.mady.by.user Stephanie Mariscal

Saved on

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.

Warningnote
titleWarning
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

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