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

Home -> Community -> Usenet -> c.d.o.server -> Re: Schema objects problem.

Re: Schema objects problem.

From: Shabble <gbarbour_at_baesystemsdotcom>
Date: Thu, 16 Jun 2005 15:29:21 +0100
Message-ID: <42b18ad3$1_1@glkas0286.greenlnk.net>


> !!!
> 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
>
>

Dmitryl

    Many Thanks!
 That was the problem! An application had created a trigger that changed the session.
Shabble.
P.S. Good people in this newsgroup, good people. :-) Received on Thu Jun 16 2005 - 09:29:21 CDT

Original text of this message

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