达梦为源端的话,dmhs用户需要权限:
create user DMHS identified by DMHS_1234;
grant PUBLIC to dmhs;
grant select on SYS.V$rlog to dmhs;
grant select on SYS.V$DM_INI to dmhs;
grant select on SYS.V$RLOGFILE to dmhs;
grant select on SYS.V$DM_ARCH_INI to dmhs;
grant select on SYS.V$VERSION to dmhs;
grant select on SYS.V$ARCH_FILE to dmhs;
grant select any table to dmhs;
grant select any dictionary to dmhs;
grant create table to dmhs;
grant create session to dmhs;
grant create trigger to dmhs;
--待装载的表或序列的查询权限:
select 'grant select on '||owner||'.'||table_name||' to "DMHS"' from dba_tables where owner='SYSDBA';
达梦为源端的话,dmhs用户需要权限:
create user DMHS identified by DMHS_1234;
grant PUBLIC to dmhs;
grant select on SYS.V$rlog to dmhs;
grant select on SYS.V$DM_INI to dmhs;
grant select on SYS.V$RLOGFILE to dmhs;
grant select on SYS.V$DM_ARCH_INI to dmhs;
grant select on SYS.V$VERSION to dmhs;
grant select on SYS.V$ARCH_FILE to dmhs;
grant select any table to dmhs;
grant select any dictionary to dmhs;
grant create table to dmhs;
grant create session to dmhs;
grant create trigger to dmhs;
--待装载的表或序列的查询权限:
select 'grant select on '||owner||'.'||table_name||' to "DMHS"' from dba_tables where owner='SYSDBA';
达梦为目的端的话,用户必须具有同步对象的操作权限及操作用户下建表的权限