Re: alter user default schema question???
- From: Roger Xu <wellmetus@xxxxxxxxx>
- To: mccdba1@xxxxxxxxx
- Date: Mon, 23 Nov 2009 16:44:59 -0600
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
>
>
>
Other related posts:
