Microsoft AzureOverview
Enable require_secure_transport on PostgreSQL flexible servers.
Rationale
SSL connectivity provides a new layer of security by connecting database servers to client applications using Secure Sockets Layer (SSL). Enforcing SSL connections between database servers and client applications helps protect against "man in the middle" attacks by encrypting the data stream between the server and the application.
Default Value
By default, secure connectivity is enforced, but some application frameworks may not enable it during deployment.
Remediation guidance
Remediate from Azure Portal
- Open the server using the
Open in Azurebutton - Under
Settings, clickServer parameters. - In the filter bar, type
require_secure_transport. - Set the
VALUEforrequire_secure_transporttoON. - Click
Save.
Remediate from Azure CLI
Use the below command to enable require_secure_transport:
az postgres flexible-server parameter set --resource-group <resourceGroup> --server-name <serverName> --name require_secure_transport --value on
Remediate from PowerShell
Update-AzPostgreSqlFlexibleServerConfiguration -ResourceGroupName <resourceGroup> -ServerName <serverName> -Name require_secure_transport -Value on
Service-wide remediation
Recommended when many resources are affected: fix the platform baseline first so new resources inherit the secure setting, then remediate the existing flagged resources in batches.
Azure
Use management group or subscription Azure Policy assignments, remediation tasks where supported, landing-zone standards, and IaC modules so drift is prevented at scale.
Operational rollout
- Fix the baseline first at the account, subscription, project, cluster, or tenant scope that owns this control.
- Remediate the currently affected resources in batches, starting with internet-exposed and production assets.
- Re-scan and track approved exceptions with an owner and expiry date.
Query logic
These are the stored checks tied to this control.
Azure PostgreSQL Flex Servers Without Secure Transport
Connectors
Covered asset types
Expected check: eq []
{
postgreSqlFlexibleServers(
where: {
configurations_SOME: {
name: "require_secure_transport"
value_MATCHES: "(?i)off"
}
}
) {
...AssetFragment
}
}
