Security Center default policy setting 'Monitor SQL Auditing' is not enabled Affecting Security Center service in Azure
CCSS (Common Configuration Scoring System) is a set of measures used to determine the severity of the rule.
Each rule is associated with a high-level category. For example IAM, Container, Monitoring, Logging, Network, etc.
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- Snyk IDSNYK-CC-00675
- creditSnyk Research Team
Description
This setting recommends that access auditing for the Azure Database be enabled for compliance, advanced threat detection, and investigation purposes.
How to fix?
Set policyDefinitionId to /providers/Microsoft.Authorization/policyDefinitions/a6fb4358-5bf4-4ad7-ba82-2cd2f41ce5e9, and set enforcementMode to Default or remove the attribute.
Example Configuration
{
"$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
"contentVersion": "1.0.0.0",
"parameters": {},
"variables": {},
"resources": [
{
"type": "Microsoft.Authorization/policyAssignments",
"apiVersion": "2019-09-01",
"name": "policy_675_allowed",
"properties": {
"displayName": "Auditing on SQL server should be enabled",
"description": "Enable application controls to define the list of known-safe applications running on your machines, and alert you when other applications run. This helps harden your machines against malware. To simplify the process of configuring and maintaining your rules, Security Center uses machine learning to analyze the applications running on each machine and suggest the list of known-safe applications.",
"enforcementMode": "Default",
"scope": "/subscriptions/5f479449-6df7-4c39-af0f-d8837aa02eec/resourcegroups/snyk_3",
"policyDefinitionId": "/providers/Microsoft.Authorization/policyDefinitions/a6fb4358-5bf4-4ad7-ba82-2cd2f41ce5e9"
}
}
]
}
Set policy_definition_id to /providers/Microsoft.Authorization/policyDefinitions/a6fb4358-5bf4-4ad7-ba82-2cd2f41ce5e9, and set enforce to true or remove the attribute.
Example Configuration
resource "azurerm_subscription_policy_assignment" "allowed" {
name = "Auditing on SQL server should be enabled"
subscription_id = data.azurerm_subscription.current.id
policy_definition_id = "/providers/Microsoft.Authorization/policyDefinitions/a6fb4358-5bf4-4ad7-ba82-2cd2f41ce5e9"
description = "Auditing on your SQL Server should be enabled to track database activities across all databases on the server and save them in an audit log"
display_name = "Auditing on SQL server should be enabled"
enforce = true
}