Troubleshooting Oracle Data Source Ingestion Error Due to Insufficient Permissions in Datahub

ingestion
1

Original Slack Thread

Hi Team,
We are trying to ingest the Oracle data source using UI into datahub version(0.12.0.4) and it got failed due to following error

[SQL: SELECT username FROM dba_users ORDER BY username]
(Background on this error at: <https://sqlalche.me/e/14/4xp6>)```
anyone please help here to resolve this issue?
2

the account you are using does not have enough permission and cannot read from dba_users table, hence the error.

3

I encountered this problem when using datahub version 0.10.1. I need to grant the incoming user the query permissions of dba_users and dba_tables.