Target Database Description

Synchronization Limitation

Foreign keys and triggers must be disabled in the target library for tables that need to be synchronized.

User Permission

Assume that mdb_user is the login user of the target MDB database. You need to change the user name in the following commands based on the actual environment.

Oracle

Oracle is a target database and the DBA role is granted to the MDB user.

grant dba to mdb_user;

-- If the oracle version is 12c 19c authorized CDB users can query the PDB
alter user c##mdbuser set container_data=all container=current;

MySQL

MySQL is a target database and grant all permissions to the MDB user.

GRANT ALL PRIVILEGES ON *.* TO "mdb_user"@"%" IDENTIFIED BY "Enmo@123" WITH GRANT OPTION; 

PostgreSQL

PostgreSQL is a target database and the superuser permission is granted to the MDB user.

alter role mdb_user with superuser;

SQL Server

SQL Server is a target database and the DBA role is granted to the MDB user.

exec sp_addrolemember 'db_owner','mdb_user';

DB2

DB2 is a target database and the DBA role is granted to the MDB user.

db2 grant dbadm on database to user mdb_user;

MogDB

MogDB is a target database and the sysadmin permission is granted to the MDB user.

alter user mdb_user with sysadmin;

When creating a MogDB database, you must specify the compatible database type. By default, it is compatible with A.

create database db1 DBCOMPATIBILITY='A';

GaussDB

GaussDB is a target database and the sysadmin permission is granted to the MDB user.

alter user mdb_user with sysadmin;

When creating a GaussDB database, you must specify the compatible database type. By default, it is compatible with A.

create database db1 DBCOMPATIBILITY='A';