迁移Oracle数据库时候,配置数据源的用户需要权限如下:
grant connect to pgchk;
grant select any table to pgchk;
grant select any dictionary to pgchk;
grant select_catalog_role to pgchk;
grant execute on dbms_metadata to pgchk;
grant select any sequence to pgchk;
grant create any procedure to pgchk;
grant create any directory to pgchk;
grant create any type to pgchk;
grant alter any trigger to pgchk;