Title: The DBMS must produce audit records containing sufficient information to establish what type of events occurred.
Vulnerability ID: V-32368
IA Controls: None
Description: Information system auditing capability is critical for accurate forensic analysis. Audit record content that may be necessary to satisfy the requirement of this control includes: time stamps, source and destination addresses, user/process identifiers, event descriptions, success/fail indications, file names involved, and access control or flow control rules invoked.
Database software is capable of a range of actions on data stored within the database. It’s important, for accurate forensic analysis, to know exactly what actions were performed. This requires specific information regarding the event type an audit record is referring to. If event type information is not recorded and stored with the audit record, the record itself is of very limited use.
Check Text: Check DBMS settings and existing audit records to verify information specific to the audit event type is being captured and stored with the audit records. If audit records exist without information regarding what type of event occurred, this is a finding.
Fix Text: Modify DBMS audit settings to include event type as part of the audit record.
SQL Server Auditing is quite robust and should be able to collect the required information for the DoD selected list of auditable events. Options are also available to use tools and components other than just SQL Server Audit. Policy Governor and PowerShell are both powerful tools that can be used along with SQL Audit to create a complete auditing solution for SQL Server.