Oracle authorizations - connect_cdc_sqdata - Latest

Connect CDC (SQData) Installation
Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Installation
Copyright
2024
First publish date
2000
Last edition
2024-07-30
Last publish date
2024-07-30T20:07:46.464596

The Oracle LogMiner Capture requires special user privileges and preparation to access and read the Oracle Recovery Logs using the Oracle LogMiner API.

Enable LogMiner functionality

  • ALTER DATABASE ADD SUPPLEMENTAL LOG DATA provides the minimal level of database metadata required by the Oracle LogMiner.

The following GRANTS are required:
  1. GRANT LOGMINING TO <sqdata_user>; (only required for Oracle 12 and above)
  2. EXECUTE authority:
    1. GRANT EXECUTE_CATALOG_ROLE TO <sqdata_user>;
    2. GRANT EXECUTE DBMS_LOGMNR TO <sqdata_user>;
    3. GRANT EXECUTE DBMS_LOGMNR_D TO <sqdata_user>;
  3. SELECT authority:
    1. GRANT SELECT ON V$LOGFILE TO <sqdata_user>;
    2. GRANT SELECT ON V$ARCHIVED_LOG TO <sqdata_user>;
    3. GRANT SELECT ON V$LOG TO <sqdata_user>;
    4. GRANT SELECT ON V$DATABASE TO <sqdata_user>;
    5. GRANT SELECT ON V$LOG_HIST TO <sqdata_user>;
    6. GRANT SELECT ON V$LOGMNR_CONTENTS TO <sqdata_user>;
    7. GRANT SELECT ON V$INSTANCE TO <sqdata_user>;
    8. GRANT SELECT ON V$THREAD TO <sqdata_user>;

    9. GRANT SELECT ANY TRANSACTION TO <sqdata_user>; authority to allow for querying the Oracle

      FLASHBACK_QUERY_TRANSACTION view

    10. GRANT SELECT MAX(SCN_BAS) from SYS.SMON_SCN_TIME TO <sqdata_user>; (9i only)
Note:
  • The LogMiner Capture requires Oracle client access (same requirements as sqlplus)
  • Each Oracle table to be captured also requires:
    ALTER TABLE <schema.tablename> ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;