Welcome to IDERA Virtual Education. My name is Bjorn Hobbed. I will be covering the database-level audit settings for SQL Compliance Manager. To edit the database-level audit settings. Right-click on the database. And select properties. Click on the audit activities tab. And here, you can decide if you do not want to audit data definition language (DDL) for this database. Any kind of schema changes, security changes, admin activities. Including any database consistency checker commands (DBCC) events or backup restore operations, data manipulation language (DML) activity. And select operations under the access check filter is where you can decide if you only want to capture events passing or failing access check. Meaning they could not perform the transaction. They did not have the permission to perform a drop database, for example. That would not mean they failed the access check. If you only want to capture those events. You would check that second option. If you want to only audit events passing access check. They actually had the permission to go and drop a database. You want to get those events. You would audit that first option. Do you want to audit both passed and failed access check. You would uncheck the filter. If you want to capture the SQL statements for data manipulation language (DML) and select activities. You check that option. And you can also capture the transaction status for data manipulation language (DML) activity. Meaning if you want to capture to be begin transaction and transaction under the data manipulation language (DML). And select filters tab is where you can be more granular. If you just need to audit a few tables. You can go and select those specific tables you want to audit. And not having to audit any of those are the tables that will then reduce the impact on the server. You can also decide if you want to audit system tables, store procedures, and views in indexes. Thank you for watching our IDERA Virtual Education.

Configuring Database Auditing In SQL Compliance Manager

IDERA SQL Compliance Manager allows you to audit sensitive data within an SQL server database so you can know who did what, when, where, and how. Track changes to the database, be alerted to suspicious activity, and satisfy audits for PCI, HIPPA, SOX, and FERPA. Learn More →

Start a FREE Trial of SQL Compliance Manager
Share This
Contact IDERA: