Re: Desparate Oracle Help...

Christopher Burke wrote:
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in
> news:tuf9uskv9kqp9f_at_corp.supernews.com:
>
> >
> > Why do you think you can't use synonyms? Did you try it at all?
>
> Yes tried, the application only picks up tables - not synonyms or views.
>
> --
> ---
> /* Christopher Burke - Spam Mail to craznar_at_hotmail.com
> |*
> \* Real mail to cburke(at)craznar(dot)com

Try having a logon trigger for the users affected which issues:

alter session set current_schema = table_owner (joe?)

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."