How to permanently change the default schema for an existing user?
I'm familiar with the "alter session set current schema" command, and I know I can put that in my login.sql script, so that it runs every time I log in. I'm also familiar with After Login triggers, but I'm hoping there's a better approach.
Is there a way to permanently change the schema associated with an existing user? I was hoping for an "alter user <user> set schema = <schema>" but that doesn't appear to be supported.
Does anyone know of a better way to do this?
Thanks,
Matt Knowles