Details
-
Task
-
Resolution: Done
-
Major
-
None
-
None
-
False
-
None
-
False
Description
The Oracle Connector documentation Creating users for the connector list the rights, the c##dbzuser needs.
The following statements are missing
GRANT SELECT ON V_$MYSTAT TO c##dbzuser CONTAINER=ALL; GRANT SELECT ON V_$STATNAME TO c##dbzuser CONTAINER=ALL;
The select appears in
https://github.com/debezium/debezium/blob/main/debezium-connector-oracle/src/main/java/io/debezium/connector/oracle/OracleConnection.java
In getSessionStatisticByName
return queryAndMap("SELECT VALUE FROM v$statname n, v$mystat m WHERE n.name='" + name + "' AND n.statistic#=m.statistic#", rs -> rs.next() ? rs.getLong(1) : 0L);
The demanded right
GRANT SELECT ANY TABLE TO c##dbzuser CONTAINER=ALL;
does not make this apparent, if someone want's to grant only the minimum rights needed for the user used in a connector.
Attachments
Issue Links
- links to
-
RHEA-2023:120698
Red Hat build of Debezium 2.3.4 release
