Page History
The IDERA SQL Secure Snapshot Summary tab lists statistics and other information about the selected snapshot. To access this information, expand the SQL Server for which you want to see its snapshots and then select a specific Snapshot.
...
The Snapshot Summary displays the following sections:
- Snapshot properties - gives . Gives general information about the snapshot, the status, the collection time, the duration, whether is its marked as a baseline snapshot or not, and any additional comments.
- Audit Summary - displays . Displays the main summary information retrieved by the snapshot such as number of objects, permissions, databases, logins, windows accounts, OS controlled windows groups, and whether Weak Password Detection is enabled or not (Click here to enable/disable Weak Health Detection)
- Accounts:. Windows accounts, OS Windows accounts, Suspect Windows accounts, Suspect OS Windows accounts, Unavailable databases, and Filters.
| Info |
|---|
Login counts may differ from what is displayed in SQL Server 2005 or later. This count displays the number of Server Principles collected. In SQL Server 2005 or later, Server Principles include Logins, Server Roles, and Certificates, while in SQL Server 2000, principles include only Logins. |
Configuration before collecting snapshots
Before snapshots are taken, you must tell SQL Secure what permission data you would like to collect and when you want SQL Secure to collect it.
...
| Tip | ||
|---|---|---|
| ||
Consider taking snapshots on a routine, scheduled basis. Because snapshots are taken over time, they can be viewed to see when changes are made to user or object permissions. |
Grooming Snapshots
Snapshots are managed through the grooming process. Grooming allows you to determine which snapshots should be deleted from the SQL Secure Repository. You can schedule grooming to occur on a routine basis, ensuring you keep only the snapshots you need. For more information, see Set Snapshot Grooming.
| Note | ||
|---|---|---|
| ||
|
Mark a snapshot as a baseline
Baseline snapshots are snapshots that will not be deleted in the grooming process. To mark snapshots as baseline, you can right-click the snapshot and choose Mark as Baseline.
...
| Tip | ||
|---|---|---|
| ||
To view which snapshot is marked as baseline, click the respective SQL Server. The Audit History section of the Server Summary properties displays a list of all snapshots in this server where you can find a Baseline column that informs you which snapshot is marked as a baseline and which ones are not. |
Managing your snapshots
In addition to the setting above, you can perform the following actions with Snapshots.
- Delete snapshots - . Right-click the respective snapshot (from the Audited SQL Servers tree or the Audit History of the Server Summary) and select Delete Snapshot.
- Collect audit data manually - . Select Take Snapshot Now from the upper section of the Snapshot Summary or click the respective SQL Server, go to the Snapshots menu, and click the same option.
...
In this situation, the server account specified on the Audited SQL Server Properties window should be an account that has been granted access to these external domains. This can be accomplished by either setting up two-way trusts between the account's domain and the external domains, or by creating pass-through accounts on all the external domains.
| Excerpt |
|---|
SQL Secure tells you who has access to what on your SQL Server databases. Learn more > > |