KFS连接oralce所需的最小权限

• 源端

1. logminer方式解析

GRANT CONNECT TO FLYSYNC;  连接数据库必备权限
GRANT CREATE SESSION TO FLYSYNC; 连接数据库必备权限
GRANT UNLIMITED TABLESPACE TO FLYSYNC;  给同步用户使用表空间权限
GRANT CREATE TABLE TO FLYSYNC;   同步用户建表权限
GRANT CREATE MINING MODEL TO FLYSYNC;  给与数据模型导出权限
GRANT LOGMINING TO FLYSYNC;   logminer归档日志访问权限
GRANT EXECUTE ON DBMS_FLASHBACK TO FLYSYNC; 执行闪回权限
GRANT EXECUTE ON DBMS_LOGMNR TO FLYSYNC;  logminer相关权限
GRANT EXECUTE ON DBMS_LOGMNR_D TO FLYSYNC;  logminer相关权限

GRANT EXECUTE ON SYS.DBMS_LOGMNR TO FLYSYNC; logminer相关权限
GRANT EXECUTE ON SYS.DBMS_LOGMNR_D TO FLYSYNC; logminer相关权限
GRANT EXECUTE ON SYS.DBMS_LOGMNR_INTERNAL TO FLYSYNC; logminer相关权限
GRANT EXECUTE ON SYS.DBMS_LOGMNR_LOGREP_DICT TO FLYSYNC; logminer相关权限
GRANT EXECUTE ON SYS.DBMS_LOGMNR_SESSION TO FLYSYNC; logminer相关权限
GRANT EXECUTE_CATALOG_ROLE TO FLYSYNC; 赋予同步用户修改数据库对象结构的权限
GRANT SELECT ANY DICTIONARY TO FLYSYNC;  oracle所有目录访问全新啊
GRANT SELECT ANY TABLE TO FLYSYNC;   所有表访问查看啊
GRANT SELECT ANY TRANSACTION TO FLYSYNC;  所有事务信息产看权限
GRANT SELECT ON SYS.V_$ARCHIVED_LOG TO FLYSYNC;  查看归档系统试图权限
GRANT SELECT ON SYS.V_$DATABASE TO FLYSYNC;  查看V_$database 系统视图权限
GRANT SELECT ON SYS.V_$LOGMNR_CONTENTS TO FLYSYNC; 查看V_$LOGMNR系统视图权限
GRANT SELECT ON V_$ARCHIVED_LOG TO FLYSYNC;   视图查看权限，同上
GRANT SELECT ON V_$DATABASE TO FLYSYNC;   视图查看权限，同上
GRANT SELECT ON V_$LOG TO FLYSYNC;   视图查看权限，同上
GRANT SELECT ON V_$LOGFILE TO FLYSYNC;   视图查看权限，同上
GRANT SELECT ON V_$LOGMNR_CONTENTS TO FLYSYNC;  视图查看权限，同上
GRANT SELECT ON V_$LOGMNR_DICTIONARY TO FLYSYNC;  视图查看权限，同上
GRANT SELECT ON V_$LOGMNR_LOGS TO FLYSYNC;  视图查看权限，同上
GRANT SELECT ON V_$LOGMNR_PARAMETERS TO FLYSYNC  视图查看权限，同上;
GRANT SELECT ON V_$PARAMETER TO FLYSYNC;  视图查看权限，同上

1. redo方式解析

GRANT CONNECT TO FLYSYNC;

GRANT CREATE SESSION TO FLYSYNC;

GRANT UNLIMITED TABLESPACE TO FLYSYNC;

GRANT CREATE TABLE TO FLYSYNC;

GRANT EXECUTE_CATALOG_ROLE TO FLYSYNC;

GRANT SELECT ANY DICTIONARY TO FLYSYNC;

GRANT SELECT ON V_$PARAMETER TO FLYSYNC;

GRANT SELECT ANY TABLE TO FLYSYNC;

• 目标端

GRANT CONNECT TO FLYSYNC;

GRANT CREATE SESSION TO FLYSYNC;

GRANT UNLIMITED TABLESPACE TO FLYSYNC;

GRANT CREATE TABLE TO FLYSYNC;

GRANT EXECUTE_CATALOG_ROLE TO FLYSYNC;

GRANT SELECT ANY DICTIONARY TO FLYSYNC;

GRANT SELECT ON V_$PARAMETER TO FLYSYNC;

GRANT INSERT ANY TABLE TO FLYSYNC;

GRANT UPDATE ANY TABLE TO FLYSYNC;

GRANT DELETE ANY TABLE TO FLYSYNC;

GRANT SELECT ANY TABLE TO FLYSYNC;

• ASM

su - grid

sqlplus / as sysasm

grant sysasm to asmfly;