apache kafka – Oracle Debezium user grants issue

I am an 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.

Read more here: Source link