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?




Other related posts: