Before you use the data cleanup feature to clean up data migration, make sure that a database user has been created for each data source and has the corresponding privileges.
OceanBase MySQL Compatible
OceanBase Oracle Compatible
Source privileges
Query table privileges:
GRANT SELECT, INSERT, UPDATE, DELETE ON db.table_name TO target_username;Query view privileges:
GRANT SELECT ON mysql.* TO target_username;
Source privileges
Write table privileges:
GRANT SELECT, INSERT, UPDATE, DELETE ON schema_name.table_name TO target_username;Query view privileges:
GRANT SELECT ANY DICTIONARY TO target_username;