Re: Schema objects problem.

"Dmitry E. Loginov" <lde_at_mpsb.ru> wrote in message news:d8rdfq$1k0f$1_at_news.caravan.ru...
>
> "Shabble" <gbarbour_at_baesystemsdotcom> wrote in message
> news:42b132b7$1_1_at_glkas0286.greenlnk.net...
> > Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> > JServer Release 8.1.7.0.0 - Production
> > Solaris 8.
> > ( Yes I know about 9, 10 etc, but these are vendor apps.)
> >
> > 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
> >
> > == and yet?
> > SQL>
> > SQL> select * from fred.bob;
> > *
> > * .. etc.
> > 483 rows selected.
> > SQL>
> > Has anyone come across this before.
> What is result of
> select SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') from dual;
>
> ???

• Logged in as the fred schema. == SYS_CONTEXT('USERENV','CURRENT_SCHEMA')

  ---

  EDWARD SQL> Now I am getting worried! Grun.