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
- In Google Cloud Console, go to SQL > Instances and select your instance
- Open the Connections tab
- Under Authorized networks, delete the entry 0.0.0.0/0
- Click Save
Source Code
Resource Type
sqladmin.googleapis.com/Instance