Check provider logo

Cloud SQL instance does not allow 0.0.0.0/0 in authorized networks

cloudsql_instance_public_access

Severitycritical
Servicecloudsql
by Prowler

Cloud SQL authorized networks are checked for the open CIDR 0.0.0.0/0 on instances using a public IP.

The finding flags configurations where a catch-all entry exists instead of specific client ranges.

Risk

Allowing 0.0.0.0/0 makes the database reachable from the Internet, degrading confidentiality and availability. Attackers can brute-force credentials, probe for vulnerable endpoints, exfiltrate data via unauthorized queries, and trigger resource exhaustion through automated scanning.

Run this check with Prowler CLI

prowler gcp --checks cloudsql_instance_public_access

Recommendation

Enforce least privilege network access:

  • Remove 0.0.0.0/0; allow only trusted, fixed IP ranges
  • Prefer private IP or Private Service Connect with VPC controls
  • Use proxied access (Cloud SQL Auth Proxy) over direct public connections
  • Apply org policies to prevent broad allowlists

Remediation

CLI

gcloud sql instances patch <INSTANCE_NAME> --authorized-networks=""

Terraform
Other
  1. In Google Cloud Console, go to SQL > Instances and select your instance
  2. Open the Connections tab
  3. Under Authorized networks, delete the entry 0.0.0.0/0
  4. Click Save

Source Code

Resource Type

sqladmin.googleapis.com/Instance

References