No column metadata in Oracle sources

[dvenza]

Hello,

Trying to import an Oracle database into datahub, I get the following warning in the connector logs:

'warnings': {'missing column information': [ ... ]

I can drill down to the tables, but then no columns are available after import.

Probably the Oracle user does not have the required permissions ?

I cannot find anything about this warning or the required permissions for the Oracle source (see also the last comments on #5905 and #5167).

Moreover, in my use case I do not need to have the system tables imported. They add a lot of noise and we have to filter them. It seems that recently some code has been merged in PR #5592 that requires acces to DBA_TABLES (without documenting it) just for this "feature".

Can we have the system table scanning as an option, that only if activated requires a user with access to the DBA_* tables ?