Re: Schema objects problem.

From: Dmitry E. Loginov <lde_at_mpsb.ru>
Date: Thu, 16 Jun 2005 15:47:36 +0400
Message-ID: <d8roqo$1ne3$1@news.caravan.ru>

"Shabble" <gbarbour_at_baesystemsdotcom> wrote in message news:42b13d40$1_1_at_glkas0286.greenlnk.net...
> > > I have a schema fred who owns a number of objects.
> > > Something happened and now he isn't able to directly access them?!
> > > For example table = bob
> > >
> > > == Logged in as the fred schema. ==
> > > SQL> select * from bob;
> > > select * from bob
> > > *
> > > ERROR at line 1:
> > > ORA-00942: table or view does not exist
> SYS_CONTEXT('USERENV','CURRENT_SCHEMA')
> -----------------------------------------------------------
> EDWARD

!!!
You should find out where the ALTER SESSION SET CURRENT SCHEMA=EDWARD statement issued now.
Check database event triggers firstly,
Examine SQLPlus Site profile (glogin.sql) and User Profile (login.sql) files,
and so on...

Dmitryl Received on Thu Jun 16 2005 - 06:47:36 CDT