1 目标库配置

1.1 创建用户及赋权

• 创建用户

    create user zcbus identified by zcbus ;

• 用户赋权

    GRANT CREATE SESSION TO ZCBUS;
    GRANT RESOURCE TO ZCBUS;
    GRANT SELECT ANY TABLE TO ZCBUS; 
    GRANT SELECT ANY DICTIONARY TO ZCBUS; 
    GRANT SELECT_CATALOG_ROLE TO ZCBUS; 
    GRANT SELECT ANY TRANSACTION TO ZCBUS;
    GRANT FLASHBACK ANY TABLE TO ZCBUS;
    GRANT DROP ANY TABLE TO ZCBUS;
    GRANT CREATE ANY TABLE TO ZCBUS;
    GRANT ALTER ANY TABLE TO ZCBUS;
    GRANT CREATE ANY INDEX TO ZCBUS;
    GRANT ALTER ANY INDEX TO ZCBUS;
    GRANT DROP ANY INDEX TO ZCBUS;
    GRANT ALTER SESSION TO ZCBUS;
    GRANT COMMENT ANY TABLE TO ZCBUS;
    GRANT INSERT ANY TABLE TO ZCBUS;
    GRANT UPDATE ANY TABLE TO ZCBUS;
    GRANT DELETE ANY TABLE TO ZCBUS;
    GRANT LOCK ANY TABLE TO ZCBUS;

或者

    GRANT DBA TO ZCBUS;

• 清理用户

    drop user zcbus cascade;

2 补充说明

2.1 配置目标数据库参数说明