Minimum privileges required when an Oracle database serves as the source

GRANT ALTER SESSION to oms_user;
GRANT CREATE SESSION to oms_user;
GRANT CONNECT to oms_user;

GRANT SELECT DUAL to oms_user;
GRANT SELECT NLS_DATABASE_PARAMETERS to oms_user;
GRANT SELECT PRODUCT_COMPONENT_VERSION to oms_user;
GRANT SELECT V_$DATABASE to oms_user;

GRANT ALTER SESSION to oms_user;
GRANT CREATE SESSION to oms_user;
GRANT CONNECT to oms_user;

-- The SELECT privilege on all tables to be migrated.
GRANT SELECT on any-replicated-table to oms_user;

GRANT ALTER SESSION to oms_user;
GRANT CREATE SESSION to oms_user;
GRANT CONNECT to oms_user;

GRANT SELECT on DBA_CONSTRAINTS to oms_user;
GRANT SELECT on DBA_CONS_COLUMNS to oms_user;
GRANT SELECT on DBA_EXTENTS to oms_user;
GRANT SELECT on DBA_INDEXES to oms_user;
GRANT SELECT on DBA_IND_COLUMNS to oms_user;
GRANT SELECT on DBA_MVIEWS to oms_user;
GRANT SELECT on DBA_MVIEW_LOGS to oms_user;
GRANT SELECT on DBA_OBJECTS to oms_user;
GRANT SELECT on DBA_PART_KEY_COLUMNS to oms_user;
GRANT SELECT on DBA_SUBPART_KEY_COLUMNS to oms_user;
GRANT SELECT on DBA_TABLES to oms_user;
GRANT SELECT on DBA_TAB_COLS to oms_user;
GRANT SELECT on DBA_TAB_COLUMNS to oms_user;
GRANT SELECT on DBA_TAB_PARTITIONS to oms_user;
GRANT SELECT on DBA_TAB_SUBPARTITIONS to oms_user;
GRANT SELECT on DBA_USERS to oms_user;
GRANT SELECT on NLS_DATABASE_PARAMETERS to oms_user;
GRANT SELECT on SYS.SMON_SCN_TIME to oms_user;
GRANT SELECT on V_$INSTANCE to oms_user;
GRANT SELECT on V_$NLS_PARAMETERS to oms_user;

-- The SELECT privilege on all tables to be migrated.
GRANT SELECT on any-replicated-table to oms_user;

GRANT ALTER SESSION to oms_user;
GRANT CREATE SESSION to oms_user;
GRANT CONNECT to oms_user;

GRANT SELECT on ALL_CONSTRAINTS to oms_user;
GRANT SELECT on ALL_INDEXES to oms_user;
GRANT SELECT on ALL_IND_COLUMNS to oms_user;
GRANT SELECT on ALL_OBJECTS to oms_user; // Query object attributes.
GRANT SELECT on ALL_TAB_COLS to oms_user;
GRANT SELECT on ALL_USERS to oms_user; // Query users on whitelists and blacklists.
GRANT SELECT on DBA_CONSTRAINTS to oms_user;
GRANT SELECT on DBA_CONS_COLUMNS to oms_user;
GRANT SELECT on DBA_MVIEWS to oms_user;
GRANT SELECT on DBA_MVIEW_LOGS to oms_user; // Exclude the materialized views when you query all objects.
GRANT SELECT on DUAL to oms_user; // Query the current time and time zone of the database.
GRANT SELECT on GV_$INSTANCE to oms_user; // Query the number of nodes in RAC.
GRANT SELECT on NLS_DATABASE_PARAMETERS to oms_user; // Query the character set used by the database.
GRANT SELECT on SYS.CDEF$ to oms_user;
GRANT SELECT on SYS.COL$ to oms_user;
GRANT SELECT on SYS.CON$ to oms_user;
GRANT SELECT on SYS.ICOL$ to oms_user;
GRANT SELECT on SYS.OBJ$ to oms_user;
GRANT SELECT on SYS.USER$ to oms_user; // Query the names of blacklisted users under SYS tenant to filter out tables of these users.
GRANT SELECT on V_$ARCHIVED_LOG to oms_user; // Query archived files.
GRANT SELECT on V_$ARCHIVE_DEST to oms_user;
GRANT SELECT on V_$DATABASE to oms_user; // Query whether the supplemental_log is enabled and the access mode of Oracle.
GRANT SELECT on V_$LOG to oms_user;
GRANT SELECT on V_$LOGFILE to oms_user; // Query online logs.
GRANT SELECT on V_$LOGMNR_CONTENTS to oms_user; // Query the result set returned by LogMiner.
GRANT SELECT on V_$PARAMETER to oms_user;

GRANT EXECUTE on SYS.DBMS_LOGMNR to oms_user;

-- The SELECT privilege on all tables to be migrated. If a new table needs to be synchronized during incremental migration, the migration user must have the SELECT privilege on this table.
GRANT SELECT on any-replicated-table to oms_user;

-- The flashback and SELECT ANY TRANSACTION privileges on all tables to be migrated. (By default, flashback queries are not used and in this case the flashback privilege is not required.)
GRANT FLASHBACK on any-replicated-table to oms_user;
GRANT SELECT ANY TRANSACTION to oms_user;

-- The following privileges need to be granted in Oracle Database 12c and later versions:
GRANT LOGMINING TO oms_user;  
GRANT SELECT on DBA_PDBS to oms_user;

GRANT ALTER SESSION to oms_user;
GRANT CREATE SESSION to oms_user;
GRANT CONNECT to oms_user;

GRANT SELECT on ALL_CONSTRAINTS to oms_user;
GRANT SELECT on ALL_CONS_COLUMNS to oms_user;
GRANT SELECT on ALL_IND_EXPRESSIONS to oms_user;
GRANT SELECT on ALL_LOBS to oms_user;
GRANT SELECT on ALL_MVIEWS to oms_user;
GRANT SELECT on ALL_MVIEW_LOGS to oms_user;
GRANT SELECT on ALL_TABLES to oms_user;
GRANT SELECT on ALL_TAB_COLUMNS to oms_user;
GRANT SELECT on ALL_TAB_PRIVS to oms_user;
GRANT SELECT on ALL_TYPES to oms_user;
GRANT SELECT on ALL_USERS to oms_user;
GRANT SELECT on ALL_VIEWS to oms_user;
GRANT SELECT on DUAL to oms_user;
GRANT SELECT on NLS_DATABASE_PARAMETERS to oms_user;
GRANT SELECT on PRODUCT_COMPONENT_VERSION to oms_user;
GRANT SELECT on USER_ROLE_PRIVS to oms_user;
GRANT SELECT on V_$DATABASE to oms_user;
GRANT SELECT on V_$PWFILE_USERS to oms_user;

GRANT ALTER SESSION to oms_user;
GRANT CREATE SESSION to oms_user;
GRANT CONNECT to oms_user;

GRANT CREATE ANY TABLE to oms_user; // Create internal transaction tables to ensure the data quality for tables without a primary key.
GRANT DROP ANY TABLE to oms_user; // Drop internal transaction tables, which can be faster by partition.
GRANT INSERT ANY TABLE to oms_user;
GRANT DELETE ANY TABLE to oms_user;
GRANT UPDATE ANY TABLE to oms_user;
GRANT UNLIMITED TABLESPACE to oms_user;

GRANT ALTER ANY TABLE to oms_user;