Welcome to Idera’s Virtual Education. My name is Bjorn Hovd. I’ll be covering the Server Level Audit Settings for SQL Compliance Manager.

To change the audit settings for the server, right-click on the instance and select ‘Properties’, click on the ‘Audit Activities’ tab. Here you then have the ability to audit Logins, Failed Logins, Security Changes, DDL, Admin Activities, and User Defined events. These events are server level events meaning they do not cover events under a database. So, when you're auditing security changes and DDL, it does not cover creating a database user or a store procedure which would be covered under the database level events.

The Administrative Activities covers DBCC operations. It does not mean that it’s covering a Sys Admin or an Administrator. It only covers DBCC events here at the server level. The User Defined Events is a custom event class where you can pass information in to seek a compliance database. If you want more information on the User Defined Events, you may contact your Account Manager who can get you some more detail on how to utilize that feature.

The Access Check Filter is based on the user having permission or not to perform the transaction. If you want to capture both failed and passed access check, simply uncheck the filter. That way it will capture both failed and passed access check.

Like I said, these are server level events, so they do not cover events under the database which will be covered under the Database Level Audit Settings.

Thank you for watching Idera’s Virtual Education.

Configuring Server Level 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: