Re: alter user default schema question???

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • To: mccdba1@xxxxxxxxx
  • Date: Thu, 26 Nov 2009 12:01:08 +0200

If you can alter the connect, you can use  PROXY user.
connect userA[userB]/userapass@db

Adar Yechiel
Rechovot, Israel



dba1 mcc 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



--
//www.freelists.org/webpage/oracle-l


Other related posts: