Create Oracle User and Grant Required Permissions

Use LogMiner (Recommended for 3.3.x)

-------PDB


CREATE USER debezium IDENTIFIED BY "StrongPassword";

GRANT CONNECT, RESOURCE TO debezium;




GRANT CREATE SESSION TO debezium;




GRANT SELECT ON V_$DATABASE TO debezium;

GRANT SELECT ON V_$LOG TO debezium;

GRANT SELECT ON V_$LOGFILE TO debezium;

GRANT SELECT ON V_$ARCHIVED_LOG TO debezium;

GRANT SELECT ON V_$INSTANCE TO debezium;




GRANT FLASHBACK ANY TABLE TO debezium;

GRANT SELECT ANY TRANSACTION TO debezium;




GRANT SELECT ANY DICTIONARY TO debezium;

GRANT LOGMINING TO debezium;










ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;







ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;







---------CDB

ALTER DATABASE FORCE LOGGING;




SHOW PARAMETER db_recovery_file_dest;

SHOW PARAMETER db_recovery_file_dest_size;

CREATE USER debezium IDENTIFIED BY "StrongPassword";

GRANT CONNECT, RESOURCE TO debezium;

GRANT CREATE SESSION TO debezium;

GRANT SELECT ON V_$DATABASE TO debezium;

GRANT SELECT ON V_$LOG TO debezium;

GRANT SELECT ON V_$LOGFILE TO debezium;

GRANT SELECT ON V_$ARCHIVED_LOG TO debezium;

GRANT SELECT ON V_$INSTANCE TO debezium;

GRANT FLASHBACK ANY TABLE TO debezium;

GRANT SELECT ANY TRANSACTION TO debezium;

GRANT SELECT ANY DICTIONARY TO debezium;

GRANT LOGMINING TO debezium;

---------CDB

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

ALTER DATABASE FORCE LOGGING;

------------PDB

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

-----------------PDB

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

-------------CDB

SHOW PARAMETER db_recovery_file_dest;

SHOW PARAMETER db_recovery_file_dest_size;