-
Enhancement
-
Resolution: Unresolved
-
Major
-
None
-
None
-
False
-
False
-
See https://groups.google.com/g/debezium/c/cTkz3nwP5oY
We should see whether it's possible to validate the necessary grants at the start-up of the Oracle connector and report which are missing if any fail. Looking at the grants outlined in the docs at:
https://debezium.io/documentation/reference/1.8/connectors/oracle.html#setting-up-oracle
If the connector is configured with database.pdb.name, the grant checks should be done based on the PDB only; otherwise against the root database. Additionally, any grants that use ANY TABLE could be specified per-table in a production environment and so we either may need to omit to validate these or use the tables in the OracleDatabaseSchema to resolve these.
Lastly, some grants are not applicable to certain Oracle versions, i.e. LOGMINING and therefore the checks will need to be Oracle version-specific.