Skip to main content

🛡️ Azure Subscription Activity Log Alert for Delete SQL Server Firewall Rule does not exist🟢

  • Contextual name: 🛡️ Activity Log Alert for Delete SQL Server Firewall Rule does not exist🟢
  • ID: /ce/ca/azure/subscription/activity-log-alert-for-delete-sql-server-firewall-rule
  • Tags:
  • Policy Type: COMPLIANCE_POLICY
  • Policy Categories: SECURITY

Stats​

not available

Logic​

Similar Policies​

Similar Internal Rules​

RulePoliciesFlags
✉️ dec-x-6fc9c9491

Description​

Open File

Description​

Create an activity log alert for the Delete SQL Server Firewall Rule event.

Rationale​

Monitoring for Delete SQL Server Firewall Rule events gives insight into SQL network access changes and may reduce the time it takes to detect suspicious activity.

Impact​

There will be a substantial increase in log size if there are a large number of administrative actions on a server.

Audit​

This policy flags an Azure Subscription as INCOMPLIANT if it does not have an enabled related Azure Activity Log Alert scoped to the subscription whose Condition JSON filters on the Administrative category and the Microsoft.Sql/servers/firewallRules/delete operation.

Default Value​

By default, no monitoring alerts are created or active.

References​

  1. https://azure.microsoft.com/en-us/updates?id=classic-alerting-monitoring-retirement
  2. https://learn.microsoft.com/en-us/azure/azure-monitor/alerts/alerts-create-activity-log-alert-rule
  3. https://learn.microsoft.com/en-us/rest/api/monitor/activity-log-alerts/create-or-update

... see more

Remediation​

Open File

Remediation​

From Azure Portal​

  1. Navigate to the Monitor blade.
  2. Select Alerts.
  3. Select Create.
  4. Select Alert rule.
  5. Choose a subscription.
  6. Select Apply.
  7. Select the Condition tab.
  8. Click See all signals.
  9. Select Delete server firewall rule (Server Firewall Rule).
  10. Click Apply.
  11. Select the Actions tab.
  12. Click Select action groups to select an existing action group, or Create action group to create a new action group.
  13. Follow the prompts to choose or create an action group.
  14. Select the Details tab.
  15. Select a Resource group, provide an Alert rule name and an optional Alert rule description.
  16. Click Review + create.
  17. Click Create.

From Azure CLI​

az monitor activity-log alert create \
    --resource-group {{resource-group-name}} \
    --condition category=Administrative and operationName=Microsoft.Sql/servers/firewallRules/delete and level={{verbose | information | warning | error | critical}} \
    --scope /subscriptions/{{subscription-id}} \
    --name {{activity-log-rule-name}} \

... [see more](remediation.md)

policy.yaml​

Open File

Linked Framework Sections​

SectionSub SectionsInternal RulesPoliciesFlagsCompliance
💼 APRA CPG 234 → 💼 36a change management —information security is addressed as part of the change management process and the information asset inventory is updated;88no data
💼 APRA CPG 234 → 💼 44b deletion or corruption of both production and backup data, either through malicious intent, user error or system malfunction;67no data
💼 APRA CPG 234 → 💼 67b scanning for unauthorised hardware, software and changes to configurations;88no data
💼 CIS Azure v1.5.0 → 💼 5.2.8 Ensure that Activity Log Alert exists for Delete SQL Server Firewall Rule - Level 1 (Automated)11no data
💼 CIS Azure v2.0.0 → 💼 5.2.8 Ensure that Activity Log Alert exists for Delete SQL Server Firewall Rule - Level 1 (Automated)11no data
💼 CIS Azure v2.1.0 → 💼 5.2.8 Ensure that Activity Log Alert exists for Delete SQL Server Firewall Rule - Level 1 (Automated)11no data
💼 CIS Azure v3.0.0 → 💼 6.2.8 Ensure that Activity Log Alert exists for Delete SQL Server Firewall Rule (Automated)1no data
💼 CIS Azure v4.0.0 → 💼 7.1.2.8 Ensure that Activity Log Alert exists for Delete SQL Server Firewall Rule (Automated)1no data
💼 CIS Azure v5.0.0 → 💼 6.1.2.8 Ensure that Activity Log Alert exists for Delete SQL Server Firewall Rule (Automated)1no data
💼 CIS Azure v6.0.0 → 💼 6.1.2.8 Ensure that Activity Log Alert Exists for Delete SQL Server Firewall Rule (Automated)1no data
💼 Cloudaware Framework → 💼 Alerting and Notification42no data
💼 FedRAMP High Security Controls → 💼 AU-3(1) Additional Audit Information (M)(H)15no data
💼 FedRAMP High Security Controls → 💼 AU-12 Audit Record Generation (L)(M)(H)276no data
💼 FedRAMP High Security Controls → 💼 SI-4(20) Privileged Users (H)5159no data
💼 FedRAMP Low Security Controls → 💼 AU-12 Audit Record Generation (L)(M)(H)76no data
💼 FedRAMP Moderate Security Controls → 💼 AU-3(1) Additional Audit Information (M)(H)15no data
💼 FedRAMP Moderate Security Controls → 💼 AU-12 Audit Record Generation (L)(M)(H)76no data
💼 ISO/IEC 27001:2022 → 💼 5.28 Collection of evidence1622no data
💼 ISO/IEC 27001:2022 → 💼 8.15 Logging2035no data
💼 NIST CSF v2.0 → 💼 DE.CM-01: Networks and network services are monitored to find potentially adverse events187no data
💼 NIST CSF v2.0 → 💼 DE.CM-03: Personnel activity and technology usage are monitored to find potentially adverse events107no data
💼 NIST CSF v2.0 → 💼 DE.CM-09: Computing hardware and software, runtime environments, and their data are monitored to find potentially adverse events185no data
💼 NIST SP 800-53 Revision 5 → 💼 AU-3(1) Content of Audit Records _ Additional Audit Information1515no data
💼 NIST SP 800-53 Revision 5 → 💼 AU-12 Audit Record Generation45076no data