Neil, a solution architect at Quest Software, discusses how to configure Change Auditor for SQL data-level auditing. He emphasizes that data-level auditing is slightly different from server-level auditing, requiring fewer steps. The main prerequisite is deploying the Change Auditor agent on SQL servers, which requires .NET Framework 4.8 or newer. Configuration must be done in the Change Auditor console, not the web console.
Neil, explains the process of creating a template for auditing, including naming it based on the database, selecting SQL Server credentials, and choosing events to audit. He recommends selecting all available events due to the sensitivity of the data involved. The configuration also allows for filtering criteria and specifying tables to audit, particularly those containing sensitive information, which will be masked in the event details. Finally, he notes that enabling the template is the last step, and no additional assignment is needed for data-level auditing. He encourages viewers to reach out for technical support if needed.
