Title: The DBMS must protect audit tools from unauthorized deletion.
Vulnerability ID: V-32399
IA Controls: None
Description: Protecting audit data also includes identifying and protecting the tools used to view and manipulate log data.
Depending upon the log format and application, system and application log tools may provide the only means to manipulate and manage application and system log data.
It is, therefore, imperative that access to audit tools be controlled and protected from unauthorized access.
Applications providing tools to interface with audit data will leverage user permissions and roles identifying the user accessing the tools and the corresponding rights the user enjoys in order make access decisions regarding the access to audit tools.
Audit tools include, but are not limited to, OS provided audit tools, vendor provided audit tools, and open source audit tools needed to successfully view and manipulate audit information system activity and records.
If an attacker were to gain access to audit tools he could analyze audit logs for system weaknesses or weaknesses in the auditing itself. An attacker could also manipulate logs to hide evidence of malicious activity.
Check Text: Review access permissions to tools used to view or modify audit log data. These tools may include the DBMS itself or tools external to the database. If appropriate permissions and access controls are not applied to prevent unauthorized deletion of these tools, this is a finding.
Fix Text: Add or modify access controls and permissions to tools used to view or modify audit log data. Only authorized personnel must be able to delete these tools.[divider]
SQL Server Audit is installed during the installation of SQL Server. Specific accounts should have been used to install the application and no other accounts should have access to modify the installation. At the same time the directory in which SQL Audit, or any other audit tool, writes the logs to should also be protected by system administrators to only allow read access to only those that require access. Audit records should not be deleted, but moved to a secured, secondary storage, if long term retention is required. Audit logs should only be removed base don documented processes.