Control: 3.1.7.2 Ensure That Microsoft Defender for Open-Source Relational Databases Is Set To 'On'
Description
Turning on Microsoft Defender for Open-source relational databases enables threat detection for Open-source relational databases, providing threat intelligence, anomaly detection, and behavior analytics in the Microsoft Defender for Cloud.
Enabling Microsoft Defender for Open-source relational databases allows for greater defense-in-depth, with threat detection provided by the Microsoft Security Response Center (MSRC).
Remediation
From Azure Portal
- Go to
Microsoft Defender for Cloud
. - Under
Management
, selectEnvironment Settings
. - Click on the subscription name.
- Select the
Defender plans
blade. - Click
Select types >
in the row forDatabases
. - Set the toggle switch next to
Open-source relational databases
toOn
. - Select
Continue
. - Select
Save
.
From Azure CLI
Run the following command:
az security pricing create -n 'OpenSourceRelationalDatabases' --tier 'standard'
From Powershell
Use the below command to enable Standard pricing tier for Open-source relational databases
set-azsecuritypricing -name "OpenSourceRelationalDatabases" -pricingtier "Standard"
Default Value
By default, Microsoft Defender plan is off.
Usage
Run the control in your terminal:
powerpipe control run azure_compliance.control.cis_v300_3_1_7_2
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run azure_compliance.control.cis_v300_3_1_7_2 --share
SQL
This control uses a named query:
securitycenter_azure_defender_on_for_opensource_relational_db