Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the Source Database User Has the Permission to Parse Logs
Updated on 2022-09-21 GMT+08:00

Checking Whether the Source Database User Has the Permission to Parse Logs

Oracle -> MySQL Migration

Table 1 Checking whether the source database user has the permission to parse logs

Check Item

Whether the source database user has the permission to parse logs

Description

If the source database user does not have the log parsing permission, the incremental migration will fail.

Failure Cause and Handling Suggestion

Failure cause: The source database user does not have the EXECUTE_CATALOG_ROLE role.

Handling suggestion: Assign the required role to the user and perform the check again. Run the GRANT EXECUTE_CATALOG_ROLE TO UserName command to assign the role.

Failure cause: The source database user does not have the log parsing permission.

Handling suggestion: Assign the required role to the user and perform the check again. Run the GRANT LOGMINING TO UserName command to grant the permission.