Oracle DBA_TABLES Error 00942

[vngoncharuk]

Dear Community,
Open Metadata v. 1.8.9
Recently I faced with an error:
(oracledb.exceptions.DatabaseError) ORA-00942: table or view does not exist
[SQL: /* {"app": "OpenMetadata", "version": "1.8.9.0"} */
SELECT table_name FROM DBA_TABLES where ROWNUM < 2]
(Background on this error at: https://sqlalche.me/e/14/4xp6)

DB Oracle XE. Having grant SELECT_CATALOG_ROLE user still doesn't see DBA_TABLES view and there are no options out of the box to fix it.
There are some fixes:

• either create one more separate view to ALL_TABLES and then synonym with the name DBA_TABLES but I will need to grant manually access to ALL_TABLES from all schemas.
• another option is to "change"/"apply patch" to "OpenMetadata-1.8.9-release\ingestion\src\metadata\ingestion\source\database\oracle\connection.py" file where I need to change "CHECK_ACCESS_TO_ALL = "SELECT table_name FROM DBA_TABLES where ROWNUM < 2"" line to something which will check whether oracle XE or not and will use either DBA_TABLE or ALL_TABLES

I this something that can be achieved by another simpler way ?

KR
Vitalii