Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Desparate Oracle Help...
Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in
news:3BE80370.6F8B_at_yahoo.com:
> Try having a logon trigger for the users affected which issues:
>
> alter session set current_schema = table_owner (joe?)
Managed to do that - sqlplus now sees 'joe' as my default schema, but the application (iPlanet Metadirectory) still only sees the PLAN_TABLE for 'bob'.
-- --- /* Christopher Burke - Spam Mail to craznar_at_hotmail.com |* \* Real mail to cburke(at)craznar(dot)comReceived on Tue Nov 06 2001 - 16:37:38 CST
![]() |
![]() |