Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-7071

Replace schema tracking restriction for SYS/SYSTEM users with configurable option

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Done
    • Icon: Major Major
    • 2.5.0.Alpha1
    • None
    • oracle-connector
    • None

      We initially restricted DDL changes from SYS and SYSTEM because the Oracle database uses these accounts to generate internal DDL changes. At the time, the DDL parser was still relatively new and not fully battle-tested, so we wanted to minimize the number of possible combinations that could cause failures.

      I propose we remove the check for handling schema changes and replace it with a new, perhaps internal option called log.mining.schema_changes.username.exclude.list. This new option would default to "SYS,SYSTEM" to preserve the existing behavior but allow users to relax this restriction if they want to capture DDL for such users.

              ccranfor@redhat.com Chris Cranford
              ccranfor@redhat.com Chris Cranford
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: