Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Desparate Oracle Help...

Re: Desparate Oracle Help...

From: Christopher Burke <craznar_at_hotmail.com>
Date: 6 Nov 2001 22:37:38 GMT
Message-ID: <Xns915257BEF4188craznar@130.102.2.1>


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)com
Received on Tue Nov 06 2001 - 16:37:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US