sqlplus sys/password@host:port/SID AS SYSDBA;
CREATE USER flinkuser IDENTIFIED BY flinkpw DEFAULT TABLESPACE LOGMINER_TBS QUOTA UNLIMITED ON LOGMINER_TBS;
-- Allows users to connect to the database
  GRANT CREATE SESSION TO flinkuser; 
-- Grants users SELECT privileges on all tables in the database to read data
  GRANT SELECT ANY TABLE TO flinkuser;
--SELECT_CATALOG_ROLE is a pre-defined database role that provides permissions to view database system tables. Additionally, during the incremental phase, the logminer session relies on this permission to query table structures.
  GRANT SELECT_CATALOG_ROLE TO flinkuser;

--GRANT ANALYZE ANY is an authorization statement granting users the ability to analyze all tables, indexes, partitions, and table functions owned by any user. When a table lacks a primary key, this permission is relied upon to obtain unique indexes and use them as primary key substitutes.
  GRANT ANALYZE ANY TO flinkuser;

 --A special grant statement that gives the user SELECT permission on the V$DATABASE view, primarily used to check whether the database's archived log is enabled (LOG_MODE) and to obtain the current database's SCN locus.
  GRANT SELECT ON V_$DATABASE to flinkuser;

--EXECUTE_CATALOG_ROLE is a predefined role that primarily provides the ability to allow logminer to write the dictionary into the binlog, so changes to the table structure are also recorded in the logical log.
  GRANT EXECUTE_CATALOG_ROLE TO flinkuser;

--Grant users permission to read data through the LOGMINING component, no need to execute in 12c and lower versions.
  GRANT LOGMINING TO flinkuser;

--EXECUTE ON DBMS_LOGMNR permission is used to allow the user to execute programs within the DBMS_LOGMNR package. The DBMS_LOGMNR package is used to analyze and extract changes in the database log files.
  GRANT EXECUTE ON DBMS_LOGMNR TO flinkuser;

--GRANT EXECUTE ON DBMS_LOGMNR_D is a grant statement that gives the user execute permissions 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;

--The data query interface of logminer consists of a set of system-provided views. To read data from logminer, you need to grant access permissions to 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;