详细数据源基础配置请参考数据源管理。

若要进行周期校验，源端与目标端用户都要具备FLASHBACK ANY TABLE权限。

源端DB2授权

DB2用户不需要额外授权。

目标端YashanDB授权

授权命令如下：

YashanDB

GRANT DBA TO username;

YashanDB（开启三权分立）

GRANT CONNECT TO username WITH ADMIN OPTION;
GRANT RESOURCE TO username WITH ADMIN OPTION;
GRANT ALTER SESSION TO username WITH ADMIN OPTION;
GRANT SELECT_CATALOG_ROLE TO username WITH ADMIN OPTION;
GRANT CREATE USER TO username WITH ADMIN OPTION;
GRANT CREATE ANY TABLE TO username WITH ADMIN OPTION;
GRANT DROP ANY TABLE TO username WITH ADMIN OPTION;
GRANT ALTER ANY TABLE TO username WITH ADMIN OPTION;
GRANT COMMENT ANY TABLE TO username WITH ADMIN OPTION;
GRANT INSERT ANY TABLE TO username WITH ADMIN OPTION;
GRANT DELETE ANY TABLE TO username WITH ADMIN OPTION;
GRANT UPDATE ANY TABLE TO username WITH ADMIN OPTION;
GRANT SELECT ANY TABLE TO username WITH ADMIN OPTION;
GRANT CREATE ANY SEQUENCE TO username WITH ADMIN OPTION;
GRANT DROP ANY SEQUENCE TO username WITH ADMIN OPTION;
GRANT SELECT ANY SEQUENCE TO username WITH ADMIN OPTION;
GRANT CREATE ANY INDEX TO username WITH ADMIN OPTION;
GRANT ALTER ANY INDEX TO username WITH ADMIN OPTION;
GRANT DROP ANY INDEX TO username WITH ADMIN OPTION;
GRANT CREATE ANY SYNONYM TO username WITH ADMIN OPTION;
GRANT CREATE PUBLIC SYNONYM TO username WITH ADMIN OPTION;
GRANT DROP ANY SYNONYM TO username WITH ADMIN OPTION;
GRANT DROP PUBLIC SYNONYM TO username WITH ADMIN OPTION;
GRANT CREATE ANY VIEW TO username WITH ADMIN OPTION;
GRANT DROP ANY VIEW TO username WITH ADMIN OPTION;
GRANT CREATE ANY MATERIALIZED VIEW TO username WITH ADMIN OPTION;
GRANT DROP ANY MATERIALIZED VIEW TO username WITH ADMIN OPTION;
GRANT CREATE ANY TYPE TO username WITH ADMIN OPTION;
GRANT DROP ANY TYPE TO username WITH ADMIN OPTION;
GRANT CREATE ANY TRIGGER TO username WITH ADMIN OPTION;
GRANT DROP ANY TRIGGER TO username WITH ADMIN OPTION;
GRANT ALTER ANY TRIGGER TO username WITH ADMIN OPTION;
GRANT CREATE ANY PROCEDURE TO username WITH ADMIN OPTION;
GRANT DROP ANY PROCEDURE TO username WITH ADMIN OPTION;
GRANT SELECT ON DBA_TABLESPACES TO username WITH GRANT OPTION;
GRANT SELECT ON DBA_DATA_FILES TO username WITH GRANT OPTION;
GRANT SELECT ON DBA_TRIGGERS TO username WITH GRANT OPTION;
GRANT SELECT ON DBA_DEPENDENCIES TO username WITH GRANT OPTION;
GRANT SELECT ON DBA_USERS TO username WITH GRANT OPTION;
GRANT SELECT ON DBA_OBJECTS TO username WITH GRANT OPTION;
GRANT SELECT ON DBA_CONSTRAINTS TO username WITH GRANT OPTION;
GRANT SELECT ON DBA_INDEXES TO username WITH GRANT OPTION;
GRANT SELECT ON DBA_ROLE_PRIVS TO username WITH GRANT OPTION;
GRANT SELECT ON DBA_SYS_PRIVS TO username WITH GRANT OPTION;
GRANT SELECT ON DBA_TABLES TO username WITH GRANT OPTION;
GRANT SELECT ON DBA_TAB_COLUMNS TO username WITH GRANT OPTION;
GRANT SELECT ON DBA_CONS_COLUMNS TO username WITH GRANT OPTION;
GRANT SELECT ON DBA_CONSTRAINTS TO username WITH GRANT OPTION;