Hi,
in my 11.2 db i need to connect with a user and then switch to another automatically.
I cannot use proxy auth because the application do not support connection like myproxy[user]/proxypass.
I cannot use alter session set current schema because some triggers use the value of "USER" variable in insert.
Is there another type of switch? Or is there a method to reset USER var?
Regards