Versions Compared

Key

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

...

If your audit data fails the integrity check, the integrity check returns a list of events that have been were inserted, modified, or deleted from the selected Repository or archive database. These events are considered compromised. The integrity check also analyzes the additional data associated with Before-After and Sensitive Column auditing of DML and SELECT events, and indicates whether this data has been is compromised as well.

The integrity check results indicate:

  • How many individual event entries have been are compromised
  • How many entries of Before-After change data and column data has been are compromised
  • How many Sensitive Column entries have been are compromised

You can choose whether to mark each compromised event entry in the audit data. Marking these events changes the event class to reflect the compromise and changes the event category to Integrity Check. Use the marked audit data to help diagnose the issues and begin a forensic analysis.

Type of CompromiseNew Event ClassNew Event Category
Events were added to the audit data stream after archival
,
using another applicationEvents insertedIntegrity Check
Events stored in the selected Repository or archive database were modified using another applicationEvents modifiedIntegrity Check
Events previously stored in the selected Repository or archive database were deleted using another applicationMissing eventsIntegrity Check

To mark the compromised events as they occur in the audit data, click Mark Events.



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 

...

SQL Compliance Manager audits all activity on your server. Learn more > >

...

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