MEDIUM
Source
Trivy
ID
AZU-0028

No threat detections are set

SQL Server can alert for security issues including SQL Injection, vulnerabilities, access anomalies and data exfiltration. Ensure none of these are disabled to benefit from the best protection

Impact

Follow the appropriate remediation steps below to resolve the issue.

Use all provided threat alerts

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
resource "azurerm_sql_server" "example" {
  name                = "mysqlserver"
  resource_group_name = azurerm_resource_group.example.name
  location            = azurerm_resource_group.example.location
  version             = "12.0"
}

resource "azurerm_mssql_server_security_alert_policy" "good_example" {
  resource_group_name = azurerm_resource_group.example.name
  server_name         = azurerm_sql_server.example.name
  state               = "Enabled"
  disabled_alerts     = []
}