Give each user their own login, and use the appropriate credentials when connecting. Then you won't have to specify the schema anywhere.

...roboticus

When your only tool is a hammer, all problems look like your thumb.