Create custom organization policy constraints

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

  • datamigration.googleapis.com/ConnectionProfile
  • datamigration.googleapis.com/ConversionWorkspace
  • datamigration.googleapis.com/MigrationJob
  • datamigration.googleapis.com/PrivateConnection

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 built-in managed 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.

Benefits

You can use custom organization policies to enforce specific security policies on your Database Migration Service resources. For example, you can restrict the types of migration jobs, the engine types for connection profiles, or the networks used for private connections. These custom organization policies and restrictions help ensure compliance and governance across your organization.

Limitations

  • Policy changes don't apply retroactively to existing Database Migration Service resources.
  • An existing resource configuration remains valid even if it has non-compliant values, unless it's updated.
  • Custom constraint evaluation might add a small latency to resource creation and update requests.

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.

    Roles required to select or create a project

    • Select a project: Selecting a project doesn't require a specific IAM role—you can select any project that you've been granted a role on.
    • Create a project: To create a project, you need the Project Creator role (roles/resourcemanager.projectCreator), which contains the resourcemanager.projects.create permission. Learn how to grant roles.

    Go to project selector

  3. Verify that billing is enabled for your Google Cloud project.

  4. Install the Google Cloud CLI.

  5. If you're using an external identity provider (IdP), you must first sign in to the gcloud CLI with your federated identity.

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

    gcloud init
  7. In the Google Cloud console, on the project selector page, select or create a Google Cloud project.

    Roles required to select or create a project

    • Select a project: Selecting a project doesn't require a specific IAM role—you can select any project that you've been granted a role on.
    • Create a project: To create a project, you need the Project Creator role (roles/resourcemanager.projectCreator), which contains the resourcemanager.projects.create permission. Learn how to grant roles.

    Go to project selector

  8. Verify that billing is enabled for your Google Cloud project.

  9. Install the Google Cloud CLI.

  10. If you're using an external identity provider (IdP), you must first sign in to the gcloud CLI with your federated identity.

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

    gcloud init
  12. 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.

Database Migration Service supported resources

The following table lists the Database Migration Service resources that you can reference in custom constraints.

Resource Field
datamigration.googleapis.com/ConnectionProfile resource.alloydb.clusterId
resource.alloydb.settings.databaseVersion
resource.alloydb.settings.encryptionConfig.kmsKeyName
resource.alloydb.settings.initialUser.user
resource.alloydb.settings.primaryInstanceSettings.databaseFlags
resource.alloydb.settings.primaryInstanceSettings.instanceNetworkConfig.authorizedExternalNetworks.cidrRange
resource.alloydb.settings.primaryInstanceSettings.instanceNetworkConfig.enableOutboundPublicIp
resource.alloydb.settings.primaryInstanceSettings.instanceNetworkConfig.enablePublicIp
resource.alloydb.settings.primaryInstanceSettings.machineConfig.cpuCount
resource.alloydb.settings.primaryInstanceSettings.machineConfig.machineType
resource.alloydb.settings.vpcNetwork
resource.cloudsql.settings.activationPolicy
resource.cloudsql.settings.autoStorageIncrease
resource.cloudsql.settings.availabilityType
resource.cloudsql.settings.cmekKeyName
resource.cloudsql.settings.collation
resource.cloudsql.settings.databaseFlags
resource.cloudsql.settings.databaseVersion
resource.cloudsql.settings.databaseVersionName
resource.cloudsql.settings.dataCacheConfig.dataCacheEnabled
resource.cloudsql.settings.dataDiskProvisionedIops
resource.cloudsql.settings.dataDiskProvisionedThroughput
resource.cloudsql.settings.dataDiskSizeGb
resource.cloudsql.settings.dataDiskType
resource.cloudsql.settings.edition
resource.cloudsql.settings.ipConfig.allocatedIpRange
resource.cloudsql.settings.ipConfig.authorizedNetworks.expireTime
resource.cloudsql.settings.ipConfig.authorizedNetworks.label
resource.cloudsql.settings.ipConfig.authorizedNetworks.ttl
resource.cloudsql.settings.ipConfig.authorizedNetworks.value
resource.cloudsql.settings.ipConfig.enableIpv4
resource.cloudsql.settings.ipConfig.privateNetwork
resource.cloudsql.settings.ipConfig.requireSsl
resource.cloudsql.settings.secondaryZone
resource.cloudsql.settings.sourceId
resource.cloudsql.settings.storageAutoResizeLimit
resource.cloudsql.settings.tier
resource.cloudsql.settings.zone
resource.displayName
resource.mysql.cloudSqlId
resource.mysql.host
resource.mysql.port
resource.mysql.ssl.sslFlags
resource.mysql.ssl.type
resource.mysql.username
resource.name
resource.oracle.forwardSshConnectivity.hostname
resource.oracle.forwardSshConnectivity.port
resource.oracle.forwardSshConnectivity.username
resource.oracle.host
resource.oracle.oracleAsmConfig.asmService
resource.oracle.oracleAsmConfig.hostname
resource.oracle.oracleAsmConfig.port
resource.oracle.oracleAsmConfig.ssl.sslFlags
resource.oracle.oracleAsmConfig.ssl.type
resource.oracle.oracleAsmConfig.username
resource.oracle.port
resource.oracle.privateConnectivity.privateConnection
resource.oracle.ssl.sslFlags
resource.oracle.ssl.type
resource.oracle.username
resource.postgresql.alloydbClusterId
resource.postgresql.cloudSqlId
resource.postgresql.database
resource.postgresql.host
resource.postgresql.port
resource.postgresql.privateServiceConnectConnectivity.serviceAttachment
resource.postgresql.ssl.sslFlags
resource.postgresql.ssl.type
resource.postgresql.username
resource.provider
resource.role
resource.sqlserver.backups.gcsBucket
resource.sqlserver.backups.gcsPrefix
resource.sqlserver.cloudSqlId
resource.sqlserver.cloudSqlProjectId
resource.sqlserver.database
resource.sqlserver.dbmPort
resource.sqlserver.forwardSshConnectivity.hostname
resource.sqlserver.forwardSshConnectivity.port
resource.sqlserver.forwardSshConnectivity.username
resource.sqlserver.host
resource.sqlserver.port
resource.sqlserver.privateConnectivity.privateConnection
resource.sqlserver.privateServiceConnectConnectivity.serviceAttachment
resource.sqlserver.ssl.sslFlags
resource.sqlserver.ssl.type
resource.sqlserver.username
resource.state
datamigration.googleapis.com/ConversionWorkspace resource.destination.engine
resource.destination.version
resource.destinationProvider
resource.displayName
resource.globalSettings
resource.name
resource.source.engine
resource.source.version
resource.sourceProvider
datamigration.googleapis.com/MigrationJob resource.cmekKeyName
resource.conversionWorkspace.commitId
resource.conversionWorkspace.name
resource.destination
resource.destinationDatabase.engine
resource.destinationDatabase.provider
resource.displayName
resource.dumpFlags.dumpFlags.name
resource.dumpFlags.dumpFlags.value
resource.dumpPath
resource.dumpType
resource.filter
resource.name
resource.objectsConfig.sourceObjectsConfig.objectConfigs.objectIdentifier.database
resource.objectsConfig.sourceObjectsConfig.objectConfigs.objectIdentifier.schema
resource.objectsConfig.sourceObjectsConfig.objectConfigs.objectIdentifier.table
resource.objectsConfig.sourceObjectsConfig.objectConfigs.objectIdentifier.type
resource.objectsConfig.sourceObjectsConfig.objectsSelectionType
resource.oracleToPostgresConfig.oracleSourceConfig.binaryLogParser.logFileDirectories.archivedLogDirectory
resource.oracleToPostgresConfig.oracleSourceConfig.binaryLogParser.logFileDirectories.onlineLogDirectory
resource.oracleToPostgresConfig.oracleSourceConfig.cdcStartPosition
resource.oracleToPostgresConfig.oracleSourceConfig.maxConcurrentCdcConnections
resource.oracleToPostgresConfig.oracleSourceConfig.maxConcurrentFullDumpConnections
resource.oracleToPostgresConfig.oracleSourceConfig.skipFullDump
resource.oracleToPostgresConfig.postgresDestinationConfig.maxConcurrentConnections
resource.oracleToPostgresConfig.postgresDestinationConfig.transactionTimeout
resource.performanceConfig.dumpParallelLevel
resource.reverseSshConnectivity.vm
resource.reverseSshConnectivity.vmIp
resource.reverseSshConnectivity.vmPort
resource.reverseSshConnectivity.vpc
resource.source
resource.sourceDatabase.engine