last sync: 2020-Oct-23 19:29:54 UTC

Azure Policy

Auditing on SQL server should be enabled

Name Auditing on SQL server should be enabled
Id a6fb4358-5bf4-4ad7-ba82-2cd2f41ce5e9
Version 2.0.0
details on versioning
Category SQL
Description Auditing on your SQL Server should be enabled to track database activities across all databases on the server, except Synapse, and save them in an audit log.
Mode Indexed
Type BuiltIn
Preview FALSE
Deprecated FALSE
Effect Default: AuditIfNotExists
Allowed: (AuditIfNotExists,Disabled)
Used RBAC Role none
History
Date/Time (UTC ymd) (i) Change type Change detail
2020-01-10 16:39:23 change Previous DisplayName: Auditing should be enabled on advanced data security settings on SQL Server
Used in Initiatives
Initiative DisplayName Initiative Id
[Deprecated]: DOD Impact Level 4 8d792a84-723c-4d92-a3c3-e4ed16a2d133
[Preview]: Azure Security Benchmark 42a694ed-f65e-42b2-aa9e-8052e9740a92
[Preview]: NIST SP 800-171 R2 03055927-78bd-4236-86c0-f36125a10dc9
[Preview]: SWIFT CSP-CSCF v2020 3e0c67fc-8c7c-406c-89bd-6b6bdc986a22
Canada Federal PBMM 4c4a5f27-de81-430b-b4e5-9cbd50595a87
CIS Microsoft Azure Foundations Benchmark 1.1.0 1a5bb27d-173f-493e-9568-eb56638dde4d
Enable Monitoring in Azure Security Center 1f3afdf9-d0c9-4c3d-847f-89da613e70a8
FedRAMP High d5264498-16f4-418a-b659-fa7ef418175f
FedRAMP Moderate e95f5a9f-57ad-4d03-bb0b-b1d16db93693
HITRUST/HIPAA a169a624-5599-4385-a696-c8d643089fab
IRS1075 September 2016 105e0327-6175-4eb2-9af4-1fba43bdb39d
ISO 27001:2013 89c6cddc-1c73-4ac1-b19c-54d1a15a42f2
ISO 27001:2013 89c6cddc-1c73-4ac1-b19c-54d1a15a42f2
NIST SP 800-53 R4 cf25b9c1-bd23-4eb6-bd2c-f4f3ac644a5f
PCI v3.2.1:2018 496eeda9-8f2f-4d5e-8dfd-204f0a92ed41
PCI v3.2.1:2018 496eeda9-8f2f-4d5e-8dfd-204f0a92ed41
UK OFFICIAL and UK NHS 3937f550-eedd-4639-9c5e-294358be442e
Json
{
  "properties": {
    "displayName": "Auditing on SQL server should be enabled",
    "policyType": "BuiltIn",
    "mode": "Indexed",
    "description": "Auditing on your SQL Server should be enabled to track database activities across all databases on the server, except Synapse, and save them in an audit log.",
    "metadata": {
      "version": "2.0.0",
      "category": "SQL"
    },
    "parameters": {
      "effect": {
        "type": "String",
        "metadata": {
          "displayName": "Effect",
          "description": "Enable or disable the execution of the policy"
        },
        "allowedValues": [
          "AuditIfNotExists",
          "Disabled"
        ],
        "defaultValue": "AuditIfNotExists"
      },
      "setting": {
        "type": "String",
        "metadata": {
          "displayName": "Desired Auditing setting"
        },
        "allowedValues": [
          "enabled",
          "disabled"
        ],
        "defaultValue": "enabled"
      }
    },
    "policyRule": {
      "if": {
        "allOf": [
          {
            "field": "type",
            "equals": "Microsoft.Sql/servers"
          },
          {
            "field": "kind",
            "notContains": "analytics"
          }
        ]
      },
      "then": {
      "effect": "[parameters('effect')]",
        "details": {
          "type": "Microsoft.Sql/servers/auditingSettings",
          "name": "default",
          "existenceCondition": {
            "field": "Microsoft.Sql/auditingSettings.state",
          "equals": "[parameters('setting')]"
          }
        }
      }
    }
  },
  "id": "/providers/Microsoft.Authorization/policyDefinitions/a6fb4358-5bf4-4ad7-ba82-2cd2f41ce5e9",
  "type": "Microsoft.Authorization/policyDefinitions",
  "name": "a6fb4358-5bf4-4ad7-ba82-2cd2f41ce5e9"
}