What to track for compliance for Snare MSSQL Agent

Owned by Carlos Osorio
Nov 09, 2020
1 min read


SUMMARY

Jul 06, 2015

The Snare Enterprise Agent for MSSQL can meet your compliance requirements. These following features below are core components to meet PCI DSS, HIPAA, FISMA etc tracking of administrative activity within the SQL Server environments:

  • Track administrative activity from within the SQL database or instance that the windows OS is unaware of

  • Track access to tables or sensitive parts of tables for any activity such as select, insert, update, delete

  • Track data loss from the use of truncation of tables or databases

  • Track the creation of new tables and migration of data from table to table

  • Track changes to SQL server built in accounts such as additions, deletions or changes to sysadmin role super user activity

  • Track SQL server configuration and policy changes

  • The configuration is flexible to allow tracking of all activity or just selected privileged user or specific user activity. If the application technical controls are sufficient then only sysadmin/DBA activity would need to be tracked as being a super user they can override technical controls

  • Easy to use interface to track your SQL server auditing needs from one central point