You set the default schema based on the user who is logging in via the connection, not the connection itself.
ALTER USER Mary51 WITH DEFAULT_SCHEMA = Purchasing;
Reference:
- ALTER USER
You set the default schema based on the user who is logging in via the connection, not the connection itself.
ALTER USER Mary51 WITH DEFAULT_SCHEMA = Purchasing;
Reference: