SYMPTOM:
The list of tables are not limited to the specified user when viewed in Warehouse Catalog connecting to Spark SQL using Strategy Developer. The DB user specified in Database Connection does not have access to tables created by other DB users, but those tables are visible in Warehouse Catalog, resulting additional time for loading tables as well as security concern.
STEPS TO REPRODUCE:
Note: The issue can be reproduced with DB Query Tool as well because the problem is caused by the ODBC driver. The option for "Use Current Schema for Catalog Functions" is not working.

CAUSE:
This is a known issue with Strategy 10.x.
ACTION:
This issue has been addressed with Strategy 10.4.6 and above. Please consider upgrading to this version or newer.
KB439319