Updated on 2023-02-15 GMT+08:00

Full Synchronization Error: permission denied for schema ***

Scenarios

During full synchronization, an error is reported, and the log information is as follows: service DATAMOVE failed, cause by: retry structures failed events=the fail structures are [type=table_structure, index=0, schema_name=%s, object_name=%s]reason:[ERROR: permission denied for schema %s]

Possible Causes

The destination database user does not have the create permission on the schema.

Solution

  1. Run the following SQL statement in the destination database to grant the create permission on the schema to which the table owner belongs:

    grant create on schema <schema_name> to <table_owner_in_source>;

  2. On the Data Synchronization Management page, click Resume to resume the synchronization task.