flink cdc读取oracle数据，需要的最小权限列表是什么，DBA反馈给的权限过大，不同意这么

Flink CDC Oracle用户权限不足 版本：flink1.14.5 、flinkcdc 2.2.1、oracle11g、 flink cdc 实时抽取oracle的数据表。DBA为了数据库安全考虑，对访问用户权限进行控制。将oracle的flinkuser用户XE下的orders表授权只读权限给readuser用户，

readuser用户没有读取表权限，但是已经授权表权限且通过dbeaver可以查询数据表。readuser没有建表权限，需要授权建表权限。

授权完成后再次执行flink cdc任务，就能正常抽取数据了。

需要创建CDC专用用户为它赋予权限。示例如下：

# 示例路径/opt/oracle/oradata/SID/，需要提前创建好并赋予权限
CREATE TABLESPACE logminer_tbs DATAFILE '/opt/oracle/oradata/SID/logminer_tbs.dbf' SIZE 25M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
CREATE USER flinkuser IDENTIFIED BY flinkpw DEFAULT TABLESPACE LOGMINER_TBS QUOTA UNLIMITED ON LOGMINER_TBS;

GRANT CREATE SESSION TO flinkuser;
GRANT SET CONTAINER TO flinkuser;
GRANT SELECT ON V_$DATABASE to flinkuser;
GRANT FLASHBACK ANY TABLE TO flinkuser;
GRANT SELECT ANY TABLE TO flinkuser;
GRANT SELECT_CATALOG_ROLE TO flinkuser;
GRANT EXECUTE_CATALOG_ROLE TO flinkuser;
GRANT SELECT ANY TRANSACTION TO flinkuser;
GRANT LOGMINING TO flinkuser;

GRANT CREATE TABLE TO flinkuser;
GRANT LOCK ANY TABLE TO flinkuser;
GRANT ALTER ANY TABLE TO flinkuser;
GRANT CREATE SEQUENCE TO flinkuser;

GRANT EXECUTE ON DBMS_LOGMNR TO flinkuser;
GRANT EXECUTE ON DBMS_LOGMNR_D TO flinkuser;

GRANT SELECT ON V_$LOG TO flinkuser;
GRANT SELECT ON V_$LOG_HISTORY TO flinkuser;
GRANT SELECT ON V_$LOGMNR_LOGS TO flinkuser;
GRANT SELECT ON V_$LOGMNR_CONTENTS TO flinkuser;
GRANT SELECT ON V_$LOGMNR_PARAMETERS TO flinkuser;
GRANT SELECT ON V_$LOGFILE TO flinkuser;
GRANT SELECT ON V_$ARCHIVED_LOG TO flinkuser;
GRANT SELECT ON V_$ARCHIVE_DEST_STATUS TO flinkuser;

flink cdc 实时抽取oracle的数据表。DBA为了数据库安全考虑，对访问用户权限进行控制。将oracle的flinkuser用户XE下的orders表授权只读权限给readuser用户，readuser建表权限，授权建表权限，grant resource to readuser;