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

Original Slack Thread

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

[SQL: SELECT username FROM dba_users ORDER BY username]
(Background on this error at: <>)```
anyone please help here to resolve this issue?

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

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.