alter user default schema question???
- From: dba1 mcc <mccdba1@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 23 Nov 2009 14:27:14 -0800 (PST)
we have ORACLE 10GR2 on LINUX server. one of our user request he want login as
"userA", but when he login (through ODBC and third party tool) the defaut
schema must be "userB".
in this case we can NOT use "alter session set current_schema = siebel".
Does anyone has solution for this?
Thanks.
--
http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- Re: alter user default schema question???
- From: Roger Xu
- Re: alter user default schema question???
- From: Martin Ruthner
- Re: alter user default schema question???
- From: Yechiel Adar
- Re: alter user default schema question???
Other related posts:
- » alter user default schema question??? - dba1 mcc
- » Re: alter user default schema question??? - Roger Xu
- » Re: alter user default schema question??? - Martin Ruthner
- » Re: alter user default schema question??? - Kellyn Pedersen
- » Re: alter user default schema question??? - Yechiel Adar