It seems login trigger is one of the solution. //www.freelists.org/post/oracle-l/change-users-default-schema,1 On Mon, Nov 23, 2009 at 4:27 PM, dba1 mcc <mccdba1@xxxxxxxxx> wrote: > 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. > > > > > -- > //www.freelists.org/webpage/oracle-l > > >