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-00685
- creditSnyk Research Team
Description
Monitoring for "Create or Update or Delete SQL Server Firewall Rule" events gives insight into network access changes and may reduce the time it takes to detect suspicious activity.
How to fix?
Set field operationName to Microsoft.Sql/servers/firewallRules/write and set enabled to true or remove the attribute.
Example Configuration
{
"$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
"contentVersion": "1.0.0.0",
"resources": [
{
"type": "Microsoft.Insights/activityLogAlerts",
"apiVersion": "2017-04-01",
"name": "default",
"location": "global",
"properties": {
"scopes": [
"[subscription().id]"
],
"condition": {
"allOf": [
{
"field": "category",
"equals": "Administrative"
},
{
"field": "operationName",
"equals": "Microsoft.Sql/servers/firewallRules/write"
}
]
},
"actions": {
"actionGroups": []
}
}
}
]
}
Set criteria.operation_name to Microsoft.Sql/servers/firewallRules/write and set enabled to true or remove the attribute.
Example Configuration
resource "azurerm_monitor_activity_log_alert" "allowed1" {
name = "exalert685"
resource_group_name = azurerm_resource_group.example685.name
scopes = [azurerm_resource_group.example685.id]
criteria {
operation_name = "Microsoft.Sql/servers/firewallRules/write"
category = "Administrative"
}
}