SQL Server auditing retention period is less than 90 days Affecting Database service in Azure


Severity

0.0
medium
0
10
Severity Framework
Snyk CCSS
Rule category
Logging/ Retention

Is your environment affected by this misconfiguration?

In a few clicks we can analyze your entire application and see what components are vulnerable in your application, and suggest you quick fixes.

Test your applications
Frameworks
CIS-AzureCIS-ControlsCSA-CCMSOC-2
  • Snyk IDSNYK-CC-00453
  • creditSnyk Research Team

Description

Audit logs can be used to check for anomalies and give insight into suspected breaches or misuse of information and access.

How to fix?

Set properties.retentionDays attribute to 90 or greater. Alternatively set the value to 0 to retain records indefinitely in extendedAuditingSettings resource.