Versions Compared

Key

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

IDERA SQL Compliance Manager audits and reports on the frequency that users access sensitive data, alerting about suspicious behavior.

The Row Count feature allows users to: 

  • Audit and capture row count for all event types and SQL statements. 
  • Audit and capture row count for joined query statements.
  • Report on row count and access to data and sensitive data. 
  • Set alerts based on thresholds for row counts, users, sensitive data, and specific queries.   

Row count information is captures as part of an audit event and gathers information from both, traces and extended events. 

Note

The row count functionality is only available for SQL Server 2008 and above.