Versions Compared

Key

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

...

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

When a snapshot should be marked as baselineImportance
When you take your first snapshotTo have a starting point to use to identify changes to permissions over time
At the end of the month, quarter, or yearTo track compliance to your database security policies
When you implement a new security modelTo identify unwanted changes or issues with the new model
When you notice problems or irregularities in permission settings in a snapshotTo analyze the issue to correct problems and change permissions settings
Tip
titleViewing which snapshot is marked as baseline

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.  

...

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.


Scroll pdf ignore
Excerpt
SQL Secure manages SQL Server security and permissions.
 | Products Buy Support Community About Us | Resources