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: