tencent cloud

sqlplus sys/password@host:port/SID AS SYSDBA;
CREATE USER flinkuser IDENTIFIED BY flinkpw DEFAULT TABLESPACE LOGMINER_TBS QUOTA UNLIMITED ON LOGMINER_TBS;
-- Allow users to connect to the database
  GRANT CREATE SESSION TO flinkuser; 
-- To support scenarios using cdb/pdb, grant users access to pdb/cdb
  GRANT SET CONTAINER TO flinkuser;
-- Grant users SELECT privileges on all tables in the database to read data
  GRANT SELECT ANY TABLE TO flinkuser;
--SELECT_CATALOG_ROLE is a predefined database role that provides permissions to view database system tables. Additionally, during the incremental phase, the logminer session relies on this privilege to query the table structure.
  GRANT SELECT_CATALOG_ROLE TO flinkuser;

--GRANT ANALYZE ANY is a grant statement used to authorize users to analyze all tables, indexes, partitions, and table functions owned by any user. When a table does not have a primary key, this privilege is used to obtain the unique index and replace the primary key with the unique index.
  GRANT ANALYZE ANY TO flinkuser;

 --A special grant statement that grants the user the SELECT privilege on the V$DATABASE view, mainly used to check whether the database's archived log is enabled (LOG_MODE) and to get the current SCN Point of the database.
  GRANT SELECT ON V_$DATABASE to flinkuser;

--EXECUTE_CATALOG_ROLE is a predefined role that mainly provides the capability for logminer to write the dictionary to the binlog, thus recording changes in the table structure into the logical log.
  GRANT EXECUTE_CATALOG_ROLE TO flinkuser;

--Allow the user to read data through the LOGMINING component
  GRANT LOGMINING TO flinkuser;

--The EXECUTE ON DBMS_LOGMNR privilege is used to grant the user the ability to execute programs within the DBMS_LOGMNR package. The DBMS_LOGMNR package is used to analyze and extract changed data from database log files.
  GRANT EXECUTE ON DBMS_LOGMNR TO flinkuser;

--GRANT EXECUTE ON DBMS_LOGMNR_D is a grant statement that gives the user execution privileges on the DBMS_LOGMNR_D package. DBMS_LOGMNR_D is an Oracle-provided package used to analyze online and archived redo log files at the database level
  GRANT EXECUTE ON DBMS_LOGMNR_D TO flinkuser;

--Logminer's data query interface is composed of a set of system-provided views. To read data from logminer, you need permissions to access the following views.
  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;

  exit;

 ALTER TABLE SCHEMA_NAME.TBALE_NAME ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS