1. Oracle GoldenGate Microservices Documentation
  2. Prepare
  3. Prepare Databases
  4. SQL Server
  5. Prepare Database Users and Privileges
  6. Google Cloud SQL for SQL Server

Google Cloud SQL for SQL Server

The following user requirements and minimum database privileges and permissions are required for Oracle GoldenGate to capture from and apply to a Google Cloud SQL for SQL Server database:

  1. Create a dedicated login for Oracle GoldenGate Google Cloud SQL for SQL Server. The user must be created from within the Users section of the Google Cloud dashboard for the database instance.

  2. Add the user to the source or target database.

  3. Create a schema in the source or target database, to be used for objects required for Oracle GoldenGate. This schema should map to the GGSCHEMA value used in the GLOBALS parameter file.

  4. If the database is to be used as a source for an Extract, manually enable the database for Change Data Capture (CDC):

    EXEC msdb.dbo.gcloudsql_cdc_enable_db 'source_database';

  5. Enable the following privileges and permissions for the Oracle GoldenGate user based on whether the user is for an Extract, or for a Replicat.

Table 4-6 Privileges and Permissions for Oracle GoldenGate User

Privilege Extract Replicat Syntax

User Database Roles and Privileges

DBOWNER

Yes

Yes

ALTER ROLE db_owner ADD MEMBER gguser;