Title: The DBMS must produce audit records containing sufficient information to establish the identity of any user/subject or process associated with the event.
Vulnerability ID: V-32374
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 is important, for accurate forensic analysis, to know exactly who performed a given action. If user identification 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 a user name associated with the event is being captured and stored with the audit records. If audit records exist without specific user information, this is a finding.
Fix Text: Modify DBMS audit settings to include user name as part of the audit record.[divider]
Bascially, make sure you are capturing information such as the IP addresses, user account information, time stamps, etc. to be able to accurately identify the identity of the user or application that performed an action in the SQL Server.