Before you archive data using the data archiving feature, make sure that a database user has been created for each data source and has the appropriate privileges.
OceanBase MySQL Compatible
OceanBase Oracle Compatible
Source privileges
Query table privileges:
GRANT SELECT ON db.table_name TO target_username;Query view privileges:
GRANT SELECT ON mysql.* TO target_username;
Target privileges
Write to 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
Query table privileges:
GRANT SELECT ON schema_name.table_name TO target_username;Query view privileges:
GRANT SELECT ANY DICTIONARY TO target_username;
Target privileges
Write to 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;