terraform.azure.security.azure-sqlserver-public-access-disabled.azure-sqlserver-public-access-disabled
semgrep
Author
unknown
Download Count*
License
Ensure that SQL server disables public network access
Run Locally
Run in CI
Defintion
rules:
- id: azure-sqlserver-public-access-disabled
message: Ensure that SQL server disables public network access
patterns:
- pattern: resource
- pattern-inside: |
resource "azurerm_mssql_server" "..." {
...
}
- pattern-not-inside: |
resource "azurerm_mssql_server" "..." {
...
public_network_access_enabled = false
...
}
metadata:
owasp:
- A05:2017 - Broken Access Control
- A01:2021 - Broken Access Control
cwe:
- "CWE-284: Improper Access Control"
category: security
technology:
- terraform
- azure
references:
- https://owasp.org/Top10/A01_2021-Broken_Access_Control
subcategory:
- audit
likelihood: LOW
impact: LOW
confidence: LOW
license: Commons Clause License Condition v1.0[LGPL-2.1-only]
vulnerability_class:
- Improper Authorization
languages:
- hcl
severity: WARNING
Examples
azure-sqlserver-public-access-disabled.tf
# fail
# ruleid: azure-sqlserver-public-access-disabled
resource "azurerm_mssql_server" "example" {
name = "mssqlserver"
resource_group_name = azurerm_resource_group.example.name
location = azurerm_resource_group.example.location
version = "12.0"
administrator_login = "missadministrator"
administrator_login_password = "thisIsKat11"
minimum_tls_version = "1.2"
public_network_access_enabled = true
azuread_administrator {
login_username = "AzureAD Admin"
object_id = "00000000-0000-0000-0000-000000000000"
}
}
# fail
# ruleid: azure-sqlserver-public-access-disabled
resource "azurerm_mssql_server" "example" {
name = "mssqlserver"
resource_group_name = azurerm_resource_group.example.name
location = azurerm_resource_group.example.location
version = "12.0"
administrator_login = "missadministrator"
administrator_login_password = "thisIsKat11"
minimum_tls_version = "1.2"
azuread_administrator {
login_username = "AzureAD Admin"
object_id = "00000000-0000-0000-0000-000000000000"
}
}
# pass
resource "azurerm_mssql_server" "example" {
name = "mssqlserver"
resource_group_name = azurerm_resource_group.example.name
location = azurerm_resource_group.example.location
version = "12.0"
administrator_login = "missadministrator"
administrator_login_password = "thisIsKat11"
minimum_tls_version = "1.2"
public_network_access_enabled = false
azuread_administrator {
login_username = "AzureAD Admin"
object_id = "00000000-0000-0000-0000-000000000000"
}
}
Short Link: https://sg.run/02Xk