Restrict Public IP Access for Cloud SQL Instances at Organization Level

01 Sign in to Google Cloud Management Console with the organizational unit credentials.

02 Click on the deployment selector from the top navigation bar, select ALL to list all the existing deployments, then choose the Google Cloud organization that you want to examine.

03 Navigate to Cloud Identity and Access Management (IAM) dashboard at https://console.cloud.google.com/iam-admin/iam.

04 In the navigation panel, select Organization Policies to access the list with the cloud organization policies available for your GCP organization.

05 Click inside the Filter by policy name or ID filter box, select Restrict Public IP access on Cloud SQL instances to return only the “Restrict Public IP access on Cloud SQL instances” organization policy.

06 Click on the name of the GCP organization policy returned at the previous step.

07 On the Policy details page, under Effective policy, check the Enforcement configuration attribute status. If the Enforcement attribute status is set to Not enforced, the policy is not enabled for your organization, therefore the restriction of configuring Cloud SQL database instances with public IPs is not enabled for the selected Google Cloud organization.

08 Repeat steps no. 2 – 7 for each organization available in in your Google Cloud account.

01 Run organizations list command (Windows/macOS/Linux) using custom query filters to list the ID of each GCP organization created within your Google Cloud account:

gcloud organizations list
  --format="table(name)"

02 The command output should return the requested organization IDs:

ID
112233441122
123412341234

03 Run resource-manager org-policies describe command (Windows/macOS/Linux) using the ID of the GCP organization that you want to reconfigure as identifier parameter, to describe the enforcement configuration of the “Restrict Public IP access on Cloud SQL instances” policy (i.e. "sql.restrictPublicIp"), available for the selected organization:

gcloud alpha resource-manager org-policies describe
"sql.restrictPublicIp"
  --effective
  --organization=112233441122
  --format="table(booleanPolicy)"

04 The command request should return the requested configuration information:

BOOLEAN_POLICY
{}

05 Repeat step no. 3 and 4 for each organization created within in your Google Cloud account.

01 Sign in to Google Cloud Management Console with the organizational unit credentials.

02 Click on the deployment selector from the top navigation bar, select ALL to list all the existing deployments, then choose the Google Cloud organization that you want to reconfigure.

03 Navigate to Cloud Identity and Access Management (IAM) dashboard at https://console.cloud.google.com/iam-admin/iam.

04 In the navigation panel, select Organization Policies to access the list with the cloud organization policies available for your GCP organization.

05 Click inside the Filter by policy name or ID box, select Name and Restrict Public IP access on Cloud SQL instances to list only the “Restrict Public IP access on Cloud SQL instances” policy.

06 Click on the name of the GCP organization policy listed at the previous step.

07 On the Policy details page, click on the EDIT button from the console top menu to edit the selected policy.

08 On the Edit policy configuration page, perform the following operations:

1. Under Applies to, select Customize to choose the type of the policy to apply (i.e. customized policy).
2. Under Enforcement, select On to enforce the "sql.restrictPublicIp" policy constraint. This constraint disables the capability to configure public IPs for the Cloud SQL database instances deployed in the selected Google Cloud organization.
3. Click SAVE to apply the changes and enforce the “Restrict Public IP access on Cloud SQL instances” policy constraints.

09 If required, repeat steps no. 2 – 8 to enable the policy for other organizations available in your Google Cloud account.

01 Run resource-manager org-policies enable-enforce command (Windows/macOS/Linux) using the ID of the Google Cloud Platform (GCP) organization that you want to reconfigure as identifier parameter, to enforce the “Restrict Public IP access on Cloud SQL instances” policy (i.e. "sql.restrictPublicIp" constraint) for the selected GCP organization:

gcloud alpha resource-manager org-policies enable-enforce
"sql.restrictPublicIp"
  --organization=112233441122

02 The command request should return the reconfigured organization policy metadata:

booleanPolicy:
  enforced: true
constraint: constraints/sql.restrictPublicIp
etag: aabbccddabcd
updateTime: '2020-07-18T10:00:00.000Z'

03 If required, repeat step no. 1 and 2 to enforce the policy for other GCP organizations available in your Google Cloud account.