Re: Setting CURRENT_SCHEMA externally
From: johnny_chan <johnny.chan_at_workmail.com>
Date: 2000/05/26
Message-ID: <392EE667.41ED42DE_at_workmail.com>#1/1
> > Is it possible to set a default Schema for a users?
> >
> > For example, how do I assign the user BATCH, to schema OWNER etc.
> >
> > I am aware of the following:
> >
> > I can open a session with the BATCH user and then issue the following
> > command:
> > ALTER SESSION SET CURRENT_SCHEMA = OWNER
> >
> > My problem is that I want to be able to set this as a system default
> > externally (for example, using Security Manager or Schema Manager).
> >
Date: 2000/05/26
Message-ID: <392EE667.41ED42DE_at_workmail.com>#1/1
Richard wrote:
> <ritu_at_my-deja.com> wrote in message news:8esmn1$pj3$1_at_nnrp1.deja.com...
> > Is it possible to set a default Schema for a users?
> >
> > For example, how do I assign the user BATCH, to schema OWNER etc.
> >
> > I am aware of the following:
> >
> > I can open a session with the BATCH user and then issue the following
> > command:
> > ALTER SESSION SET CURRENT_SCHEMA = OWNER
> >
> > My problem is that I want to be able to set this as a system default
> > externally (for example, using Security Manager or Schema Manager).
> >
if you are on 8i, you can set up a LOGON trigger for the schema BATCH so that it will always issue the "alter session ..." cmd on login.
jc Received on Fri May 26 2000 - 00:00:00 CEST