Restrict Authorized Networks on Cloud SQL instances
More Info:
Ensure that “Restrict Authorized Networks on Cloud SQL instances” policy is enforced for your Google Cloud Platform (GCP) organization to deny IAM members to add authorized networks in order to provide access to your security-critical SQL database instances.Risk Level
MediumAddress
Security, Operational MaturityCompliance Standards
CBPTriage and Remediation
Remediation
Using Console
Using Console
To remediate the “Restrict Authorized Networks on Cloud SQL instances” misconfiguration on GCP using the GCP console, please follow these steps:
- Login to your GCP Console and navigate to the Cloud SQL Instances page.
- Select the Cloud SQL instance that you want to remediate.
- Click on the “Edit” button at the top of the page.
- Scroll down to the “Authorized networks” section.
- Click on the “Add network” button.
- In the “Network” field, enter the IP address or CIDR range of the network that you want to authorize.
- In the “Name” field, enter a name for the network.
- Click the “Done” button.
- Repeat steps 5-8 for each network that you want to authorize.
- Once you have added all the authorized networks, click on the “Save” button at the bottom of the page.
- Verify that the authorized networks are restricted and only authorized IP addresses or CIDR ranges can access the Cloud SQL instance.
Using CLI
Using CLI
To remediate the misconfiguration of “Restrict Authorized Networks on Cloud SQL instances” for GCP using GCP CLI, follow these steps:Step 1: Open the Google Cloud Console and select the project in which the Cloud SQL instance is located.Step 2: Open the Cloud Shell by clicking on the icon in the top right corner of the console.Step 3: Run the following command to get a list of all the Cloud SQL instances in the project:Step 4: Identify the Cloud SQL instance that needs to be remediated and run the following command to update the authorized networks:Replace [INSTANCE_NAME] with the name of the Cloud SQL instance and [AUTHORIZED_NETWORKS] with the list of authorized networks in CIDR notation. For example, if you want to restrict access to a single IP address, the command would look like this:Step 5: Verify that the authorized networks have been updated by running the following command:This command will display the updated list of authorized networks for the Cloud SQL instance.Step 6: Repeat the above steps for all the Cloud SQL instances in the project that require remediation.By following these steps, you can remediate the misconfiguration of “Restrict Authorized Networks on Cloud SQL instances” for GCP using GCP CLI.
Using Python
Using Python
To remediate the misconfiguration of unrestricted authorized networks on Cloud SQL instances in GCP using Python, follow these steps:This will remove any unrestricted authorized networks from the Cloud SQL instance’s IP configuration and update the instance with the new settings.
- Import the required libraries:
- Set up the credentials for authentication:
- Set up the Cloud SQL client:
- Get the instance you want to remediate:
- Get the current authorized networks:
- Remove any unrestricted authorized networks:
- Update the instance with the new authorized networks: