Versions Compared

Key

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

...

The Snapshot Summary tab provides detailed all the information collected about your snapshot, including the time it was taken, the collection statistics, audit summary information, filter information, and a listing of any Suspect Windows accounts or unavailable databases that were encountered while the Snapshot was being taken. For more information on unresolved Windows accounts, see Identify Suspect Windows accounts. For more information on unavailable databases, see Identify Unavailable Databases.

Image Removed

some options change according the type of server.

Data located on the Snapshot Summary

...

Info

To collect and review data about the password health of your SQL logins, you need to enable the Weak password detection.

For On-premise, SQL Server on Azure VM, and SQL Server on Amazon EC2 accounts

Windows Accounts

Provides a partial list of the Windows users and groups that have access to the selected SQL Server instance either by a direct SQL Login or inherited via group membership. 

...

Lists the databases that SQL Secure was unable to collect SQL Server security data on. This can happen when a database is unavailable during SQL Secure data collection; for example, a database being backed up is unavailable for data collection. For more information, see Identify unavailable databases.

Filters

Provides the filter information associated with the selected snapshot. For more information, see Add new filter.

For Azure SQL Database Amazon RDS for SQL Server accounts

Azure AD accounts and Amazon AD accounts

Provides a list of the Azure or Amazon users and groups that have access to the selected instance either by a direct SQL Login or inherited via group membership.

Unavailable databases

Lists the databases that SQL Secure was unable to collect SQL Server security data on. For more information, see Identify unavailable databases.

Note

SQL Secure cannot collect data from the model database on RDS servers because of Amazon restrictions.

Filters

Provides the filter information associated with the selected snapshot. For more information, see Add new filter.



Scroll pdf ignore
Excerpt
SQL Secure sees who has access to what and how permissions are granted in SQL Server.
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