Homepage
About Snyk

Security Center default policy setting 'Monitor SQL Auditing' is not enabled Affecting Security Center service in Azure

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

Is your enviroment 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-Azure HIPAA SOC-2
  • Snyk ID SNYK-CC-00675
  • credit Snyk Research Team
Report a new misconfiguration Found a mistake?

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"
            }
        }
    ]
}