Question about Oracle Debezium user grants

[Xeyyam Sherif]

Hi, Coummunity, i am facing issue like this 

DebeziumException: java.sql.SQLException: ORA-31603: object \"TEST\" of type TABLE not found in schema \"TEST\"\nORA-06512: at \"SYS.DBMS_METADATA\", line 6731\nORA-06512: at \"SYS.DBMS_SYS_ERROR\",

line 105\nORA-06512: at \"SYS.DBMS_METADATA\", line 2588\nORA-06512: at \"SYS.DBMS_METADATA\", line 2827\nORA-06512: at \"SYS.DBMS_METADATA\", line 3608\nORA-06512: at \"SYS.DBMS_METADATA\", line 5008\nORA-06512: at \"SYS.DBMS_METADATA\",

line 5336\nORA-06512: at \"SYS.DBMS_METADATA\", line 6702\nORA-06512: at \"SYS.DBMS_METADATA\", line 9734\nORA-06512: at line 1\n\n\tat io.debezium.pipeline.source. I did some research and found that CATALOG_ROLE or ANY DICTIONARY access privileges are needed.

Are these mandatory? Will Debezium not work without them?

[Chris Cranford]

Hi -

Yes, these are mandatory for snapshots and when we observe a new table that is to be captured as we utilize the DBMS_METADATA.GET_DDL PL/SQL procedure to read the table's CREATE TABLE DDL.

Thanks,
-cc

--
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/debezium/16a1c77b-7bb0-467f-9bd4-de4c4c298069n%40googlegroups.com.

[Xeyyam Sherif]

Thank you for your response, Are both SELECT_CATALOG_ROLE and SELECT ANY DICTIONARY required for Debezium, or is one of them sufficient? the DBA is not willing to grant it to the Debezium user (

[Chris Cranford]

No, you only need SELECT_CATALOG_ROLE, which will give the Debezium user the ability to read the data dictionary and access to the V$ performance views necessary for log metadata queries.

To view this discussion visit https://groups.google.com/d/msgid/debezium/8ac716b5-bf79-4852-9d03-db890764df1en%40googlegroups.com.