Source Oracle: schema list is not restricted to the ones specified in the source schema

[AlexandruManolache1]

-->

Enviroment

• Airbyte version: 0.32.0 - alpha & 0.32.1 - alpha
• OS Version / Instance:Google Compute Engine
• Deployment: Docker
• Source Connector and version: Oracle DB 0.3.8
• Destination Connector and version: google storage / 0.1.3
• Severity: High
• Step where error happened:Setup new connection / Upgrade Airbyte

Current Behavior

After upgrading to 0.32.0 -> i tried to create a connection from an Oracle source:
>>> seems that when creating the connections --->> the schema list is not restricted to the ones specified in the source schema setting.
So the app tried to display all users and all schemas that the user has access to.
This is causing timeout when we have schemes with hundred of tables.
I compared the logs to another app instance on 0.30.22-alpha and the connector takes only the schemas specified in the source setting. (edited)

Expected Behavior

The connections should display / use only the tables and schemas specified the source settings as it does on 0.30.22-alpha
version

Logs

LOG

replace this with
your long log
output here

Steps to Reproduce

1. Create a oracle source that has access to multiple schemas
2. Specifiy 1 schema in the source setting
3. Create a connection using the source created at 1.
4. Check the app logs to see what schemas are rendered.

[AlexandruManolache1]

This was implemented some time ago

65efaa5 :Oracle specify schema(s) to discover. (#5779)

#5831

[AlexandruManolache1]

same behavior for 0.32.1

[AlexandruManolache1]

sorry, seems like our DBA added 10K+ table to the users access on a specific schema, this crashed the connection.