Add custom organization policies

MySQL   |  PostgreSQL   |  SQL Server

This page describes how to create, set up, and manage custom constraints in Cloud SQL instances. For an overview of custom organization policies, see custom organization policies.

Cloud SQL supported resources

This page shows you how to use Organization Policy Service custom constraints to restrict specific operations on the following Google Cloud resources:

• sqladmin.googleapis.com/Instance
• sqladmin.googleapis.com/BackupRun

To learn more about Organization Policy, see Custom organization policies.

About organization policies and constraints

The Google Cloud Organization Policy Service gives you centralized, programmatic control over your organization's resources. As the organization policy administrator, you can define an organization policy, which is a set of restrictions called constraints that apply to Google Cloud resources and descendants of those resources in the Google Cloud resource hierarchy. You can enforce organization policies at the organization, folder, or project level.

Organization Policy provides predefined constraints for various Google Cloud services. However, if you want more granular, customizable control over the specific fields that are restricted in your organization policies, you can also create custom constraints and use those custom constraints in an organization policy.

Policy inheritance

By default, organization policies are inherited by the descendants of the resources on which you enforce the policy. For example, if you enforce a policy on a folder, Google Cloud enforces the policy on all projects in the folder. To learn more about this behavior and how to change it, refer to Hierarchy evaluation rules.

Before you begin

1. Sign in to your Google Cloud account. If you're new to Google Cloud, create an account to evaluate how our products perform in real-world scenarios. New customers also get $300 in free credits to run, test, and deploy workloads.

2. In the Google Cloud console, on the project selector page, select or create a Google Cloud project.

   Note: If you don't plan to keep the resources that you create in this procedure, create a project instead of selecting an existing project. After you finish these steps, you can delete the project, removing all resources associated with the project.

   Go to project selector

3. Make sure that billing is enabled for your Google Cloud project.

4. Install the Google Cloud CLI.

5. To initialize the gcloud CLI, run the following command:

   gcloud init

6. In the Google Cloud console, on the project selector page, select or create a Google Cloud project.

   Note: If you don't plan to keep the resources that you create in this procedure, create a project instead of selecting an existing project. After you finish these steps, you can delete the project, removing all resources associated with the project.

   Go to project selector

7. Make sure that billing is enabled for your Google Cloud project.

8. Install the Google Cloud CLI.

9. To initialize the gcloud CLI, run the following command:

   gcloud init

10. Ensure that you know your organization ID.

Required roles

To get the permissions that you need to manage custom organization policies, ask your administrator to grant you the Organization Policy Administrator (roles/orgpolicy.policyAdmin) IAM role on the organization resource. For more information about granting roles, see Manage access to projects, folders, and organizations.

You might also be able to get the required permissions through custom roles or other predefined roles.

Create a custom constraint

A custom constraint is defined in a YAML file by the resources, methods, conditions, and actions that are supported by the service on which you are enforcing the organization policy. Conditions for your custom constraints are defined using Common Expression Language (CEL). For more information about how to build conditions in custom constraints using CEL, see the CEL section of Creating and managing custom constraints.

To create a custom constraint, create a YAML file using the following format:

name: organizations/ORGANIZATION_ID/customConstraints/CONSTRAINT_NAME
resourceTypes:
- RESOURCE_NAME
methodTypes:
- CREATE
- UPDATE
condition: "CONDITION"
actionType: ACTION
displayName: DISPLAY_NAME
description: DESCRIPTION

Replace the following:

• ORGANIZATION_ID: your organization ID, such as 123456789.

• CONSTRAINT_NAME: the name you want for your new custom constraint. A custom constraint must start with custom., and can only include uppercase letters, lowercase letters, or numbers, for example, custom.region. The maximum length of this field is 70 characters.

• RESOURCE_NAME: the fully qualified name of the Google Cloud resource containing the object and field you want to restrict. For example, sqladmin.googleapis.com/Instance.

• CONDITION: a CEL condition that is written against a representation of a supported service resource. This field has a maximum length of 1000 characters. See Supported resources for more information about the resources available to write conditions against. For example, "resource.region == "us-central1"".

• ACTION: the action to take if the condition is met. Possible values are ALLOW and DENY.

• DISPLAY_NAME: a human-friendly name for the constraint. This field has a maximum length of 200 characters.

• DESCRIPTION: a human-friendly description of the constraint to display as an error message when the policy is violated. This field has a maximum length of 2000 characters.

For more information about how to create a custom constraint, see Defining custom constraints.

Set up a custom constraint

After you have created the YAML file for a new custom constraint, you must set it up to make it available for organization policies in your organization. To set up a custom constraint, use the gcloud org-policies set-custom-constraint command:

gcloud org-policies set-custom-constraint CONSTRAINT_PATH

Replace CONSTRAINT_PATH with the full path to your custom constraint file. For example, /home/user/customconstraint.yaml. Once completed, your custom constraints are available as organization policies in your list of Google Cloud organization policies. To verify that the custom constraint exists, use the gcloud org-policies list-custom-constraints command:

gcloud org-policies list-custom-constraints --organization=ORGANIZATION_ID

Replace ORGANIZATION_ID with the ID of your organization resource. For more information, see Viewing organization policies.

Enforce a custom organization policy

You can enforce a boolean constraint by creating an organization policy that references it, and then applying that organization policy to a Google Cloud resource.

Console

1. In the Google Cloud console, go to the Organization policies page.

   Go to Organization policies

2. From the project picker, select the project for which you want to set the organization policy.
3. From the list on the Organization policies page, select your constraint to view the Policy details page for that constraint.
4. To configure the organization policy for this resource, click Manage policy.
5. On the Edit policy page, select Override parent's policy.
6. Click Add a rule.
7. In the Enforcement section, select whether enforcement of this organization policy is on or off.
8. Optional: To make the organization policy conditional on a tag, click Add condition. Note that if you add a conditional rule to an organization policy, you must add at least one unconditional rule or the policy cannot be saved. For more information, see Setting an organization policy with tags.
9. If this is a custom constraint, you can click Test changes to simulate the effect of this organization policy. For more information, see Test organization policy changes with Policy Simulator.
10. To finish and apply the organization policy, click Set policy. The policy requires up to 15 minutes to take effect.

gcloud

To create an organization policy that enforces a boolean constraint, create a policy YAML file that references the constraint:

      name: projects/PROJECT_ID/policies/CONSTRAINT_NAME
      spec:
        rules:
        - enforce: true
    

Replace the following:

• PROJECT_ID: the project on which you want to enforce your constraint.
• CONSTRAINT_NAME: the name you defined for your custom constraint. For example, custom.region.

To enforce the organization policy containing the constraint, run the following command:

    gcloud org-policies set-policy POLICY_PATH
    

Replace POLICY_PATH with the full path to your organization policy YAML file. The policy requires up to 15 minutes to take effect.

Example custom organization policies for common use cases

The following table provides the syntax of some custom constraints for common use cases:

Description	Constraint syntax
Ensure that instances are Enterprise Plus	name: organizations/ORGANIZATION_ID/customConstraints/custom.edition resourceTypes: - sqladmin.googleapis.com/Instance methodTypes: - CREATE - UPDATE condition: "resource.settings.edition == 'ENTERPRISE_PLUS'" actionType: ALLOW displayName: Instances must be Enterprise Plus. description: Cloud SQL instances must be Enterprise Plus.
Ensure instances are highly available	name: organizations/ORGANIZATION_ID/customConstraints/custom.availability resourceTypes: - sqladmin.googleapis.com/Instance methodTypes: - CREATE - UPDATE condition: "resource.settings.availabilityType == 'REGIONAL'" actionType: ALLOW displayName: Instances must be regional. description: Cloud SQL instances must be highly available. To do this, make them regional.
Require the SSL Mode to be enabled with encrypted connections only.	name: organizations/ORGANIZATION_ID/customConstraints/custom.sslMode resourceTypes: - sqladmin.googleapis.com/Instance methodTypes: - CREATE - UPDATE condition: "resource.settings.ipConfiguration.sslMode == 'ENCRYPTED_ONLY'" actionType: ALLOW displayName: Only allow connections that are encrypted with SSL/TLS. description: Cloud SQL instances must only allow connections that are encrypted with SSL/TLS.
Block database access from anywhere in the public internet.	name: organizations/ORGANIZATION_ID/customConstraints/custom.authorizedNetworks resourceTypes: - sqladmin.googleapis.com/Instance methodTypes: - CREATE - UPDATE condition: "resource.settings.ipConfiguration.authorizedNetworks.exists(network, network.value == '0.0.0.0/0')" actionType: DENY displayName: The list of authorized networks can't contain 0.0.0.0/0 description: Authorized networks for Cloud SQL instances can't contain 0.0.0.0/0. This allows users to access the database from any IP address.
Ensure that instances aren't created with an external IP address.	name: organizations/ORGANIZATION_ID/customConstraints/custom.ipv4Enabled resourceTypes: - sqladmin.googleapis.com/Instance methodTypes: - CREATE - UPDATE condition: "resource.settings.ipConfiguration.ipv4Enabled == false" actionType: ALLOW displayName: ipv4Enabled must be set to false. description: Cloud SQL instances can't have an external IP address.
Ensure that instances are encrypted with a KMS key.	name: organizations/ORGANIZATION_ID/customConstraints/custom.encrypted resourceTypes: - sqladmin.googleapis.com/Instance methodTypes: - CREATE - UPDATE condition: "resource.diskEncryptionConfiguration.kmsKeyName.size() > 0" actionType: ALLOW displayName: Instances must be encrypted with a KMS key. description: Cloud SQL instances must be disk-encrypted with a KMS key.
Ensure Instances are in the us-central1	name: organizations/ORGANIZATION_ID/customConstraints/custom.region resourceTypes: - sqladmin.googleapis.com/Instance methodTypes: - CREATE - UPDATE condition: "resource.region == 'us-central1'" actionType: ALLOW displayName: Instances must be in the us-central1 region. description: Cloud SQL instances must be in the us-central1 region.
Ensure that instances have data cache enabled.	name: organizations/ORGANIZATION_ID/customConstraints/custom.dataCache resourceTypes: - sqladmin.googleapis.com/Instance methodTypes: - CREATE - UPDATE condition: "resource.settings.dataCacheConfig.dataCacheEnabled == true" actionType: ALLOW displayName: Instances must have data cache enabled. description: Cloud SQL instances must have data cache enabled.
Enforce automated backups.	name: organizations/ORGANIZATION_ID/customConstraints/custom.enableBackups resourceTypes: - sqladmin.googleapis.com/Instance methodTypes: - CREATE - UPDATE condition: "resource.settings.backupConfiguration.enabled == true" actionType: ALLOW displayName: Automated backups must be enabled. description: Cloud SQL instances must have automated backups enabled.
Restrict the location of automated backups.	name: organizations/ORGANIZATION_ID/customConstraints/custom.automatedBackupLocation resourceTypes: - sqladmin.googleapis.com/Instance methodTypes: - CREATE - UPDATE condition: "resource.settings.backupConfiguration.location == 'us-central1'" actionType: ALLOW displayName: The location of automated backups must be in the us-central1 region. description: The location of automated backups for Cloud SQL instances must be in the us-central1 region.
Restrict the location of on-demand backups to us-central1	name: organizations/ORGANIZATION_ID/customConstraints/custom.onDemandBackupLocation resourceTypes: - sqladmin.googleapis.com/BackupRun methodTypes: - CREATE - UPDATE condition: "condition: resource.location == 'us-central1'" actionType: ALLOW displayName: The location of on-demand backups must be in the us-central1 region. description: On-demand backups are restricted to the us-central1.

Cloud SQL for SQL Server supported resources

The following table lists the Cloud SQL for SQL Server resources that you can reference in custom constraints.

Resource	Field
sqladmin.googleapis.com/BackupRun	resource.description
	resource.location
sqladmin.googleapis.com/Instance	resource.databaseVersion
	resource.diskEncryptionConfiguration.kmsKeyName
	resource.diskEncryptionStatus.kmsKeyVersionName
	resource.failoverReplica.name
	resource.masterInstanceName
	resource.name
	resource.project
	resource.region
	resource.replicaConfiguration.cascadableReplica
	resource.replicaConfiguration.failoverTarget
	resource.settings.activationPolicy
	resource.settings.activeDirectoryConfig.domain
	resource.settings.advancedMachineFeatures.threadsPerCore
	resource.settings.availabilityType
	resource.settings.backupConfiguration.backupRetentionSettings.retainedBackups
	resource.settings.backupConfiguration.backupRetentionSettings.retentionUnit
	resource.settings.backupConfiguration.binaryLogEnabled
	resource.settings.backupConfiguration.enabled
	resource.settings.backupConfiguration.location
	resource.settings.backupConfiguration.pointInTimeRecoveryEnabled
	resource.settings.backupConfiguration.startTime
	resource.settings.backupConfiguration.transactionLogRetentionDays
	resource.settings.collation
	resource.settings.connectorEnforcement
	resource.settings.databaseFlags.name
	resource.settings.databaseFlags.value
	resource.settings.dataCacheConfig.dataCacheEnabled
	resource.settings.dataDiskSizeGb
	resource.settings.dataDiskType
	resource.settings.deletionProtectionEnabled
	resource.settings.denyMaintenancePeriods.endDate
	resource.settings.denyMaintenancePeriods.startDate
	resource.settings.denyMaintenancePeriods.time
	resource.settings.edition
	resource.settings.enableDataplexIntegration
	resource.settings.enableGoogleMlIntegration
	resource.settings.insightsConfig.queryInsightsEnabled
	resource.settings.insightsConfig.queryPlansPerMinute
	resource.settings.insightsConfig.queryStringLength
	resource.settings.insightsConfig.recordApplicationTags
	resource.settings.insightsConfig.recordClientAddress
	resource.settings.ipConfiguration.authorizedNetworks.name
	resource.settings.ipConfiguration.authorizedNetworks.value
	resource.settings.ipConfiguration.enablePrivatePathForGoogleCloudServices
	resource.settings.ipConfiguration.ipv4Enabled
	resource.settings.ipConfiguration.privateNetwork
	resource.settings.ipConfiguration.pscConfig.allowedConsumerProjects
	resource.settings.ipConfiguration.pscConfig.pscEnabled
	resource.settings.ipConfiguration.serverCaMode
	resource.settings.ipConfiguration.sslMode
	resource.settings.locationPreference.secondaryZone
	resource.settings.locationPreference.zone
	resource.settings.maintenanceWindow.day
	resource.settings.maintenanceWindow.hour
	resource.settings.maintenanceWindow.updateTrack
	resource.settings.passwordValidationPolicy.complexity
	resource.settings.passwordValidationPolicy.disallowUsernameSubstring
	resource.settings.passwordValidationPolicy.enablePasswordPolicy
	resource.settings.passwordValidationPolicy.minLength
	resource.settings.passwordValidationPolicy.passwordChangeInterval
	resource.settings.passwordValidationPolicy.reuseInterval
	resource.settings.sqlServerAuditConfig.bucket
	resource.settings.sqlServerAuditConfig.retentionInterval
	resource.settings.sqlServerAuditConfig.uploadInterval
resource.settings.storageAutoResize
resource.settings.tier
resource.settings.timeZone

What's next

• Learn more about Organization Policy Service.
• Learn more about how to create and manage organization policies.
• See the full list of predefined organization policy constraints.