Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

alter session when login

happy10319Apr 11 2012 — edited Apr 12 2012
Hi,
on 11G R2,
I want that user3 change session to user2 just on connection. How is it possible ?

I want to avoid user3 to issue :
ALTER SESSION SET CURRENT_SCHEMA =USER2
at each connection.

Thanks for help.
This post has been answered by kuljeet singh - on Apr 11 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 10 2012
Added on Apr 11 2012
17 comments
11,348 views