It *used* to be undocumented because it used to have a
nasty memory leak (8.0 and below). When they fixed
this (in 8i), it appeared in the doco.
It may have been fixed in patches for earlier releases
- but I dunno.
hth
connor
- Dave Leach <Dave.Leach_at_claybrook.co.uk> wrote: >
>
> -----Original Message-----
> Sent: 22 August 2001 10:42
> To: 'Rahul'
>
>
> Fantastic, what a relief!!
>
> I have just looked this up on Metalink and have read
> a note saying this is
> an undocumented parameter, I'm now in 2 minds as to
> whether to use it,
> although it sounds exactly what we want.
>
> Many thanks again,
>
> Dave Leach
> -----Original Message-----
> Sent: 22 August 2001 10:29
> To: 'ORACLE-L_at_fatcity.com'
> Cc: Dave Leach
>
>
> are we talking about ....
>
> alter user set current_schema = new schema ?
>
> you require a BECOME USER priv for this
>
>
> > ----------
> > From: Dave Leach[SMTP:Dave.Leach_at_claybrook.co.uk]
> > Reply To: ORACLE-L_at_fatcity.com
> > Sent: Wednesday, August 22, 2001 5:01 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Users & Schema's
> >
> > Help!!,
> >
> > Can anyone shed some light on this or am I just
> going mad!!.
> >
> > We have a situation whereby multiple users need to
> access (both selects
> > and
> > dml) tables belonging to 1 specific schema, this
> must also be achieved
> > without prefixing the tables with the userid as
> the SQL is driven by the
> > application and is not configurable.
> >
> > My original idea was to use synonyms but I am sure
> that I have read
> > somewhere that in 8i there was an alternative to
> this whereby a user can
> > be
> > set up to use another users schema eg. USERA when
> logged on will
> > effectively
> > be treated as if they are logged on as USERB. I
> have searched every bit
> > of
> > documentation I can find (manuals, metalink etc)
> but can find no mention
> > of
> > this, have I just dreamn't this or can someone
> shed some light.
> >
> > Many thanks for any replies.
> >
> > Dave Leach
> >
> >
> >
>
> > The above information is confidential to the
> addressee and may be
> > privileged. Unauthorised access and use is
> prohibited.
> >
> > Internet communications are not secure and
> therefore this Company does
> > not accept legal responsibility for the contents
> of this message.
> >
> > If you are not the intended recipient, any
> disclosure, copying,
> > distribution or any action taken or omitted to be
> taken in reliance on
> > it, is prohibited and may be unlawful.
> >
> > Claybrook Computing Limited is a subsidiary of
> > Claybrook Computing (Holdings) Limited
> > Registered Office: Abbey House. 282 Farnborough
> Road, Farnborough,
> > Hampshire GU14 7NJ
> > Registered in England and Wales No 1287205
> >
> > A Hogg Robinson plc company
> >
>
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Dave Leach
> > INET: Dave.Leach_at_claybrook.co.uk
> >
> > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California -- Public Internet
> access / Mailing Lists
> >
>
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be
> removed from). You may
> > also send the HELP command for other information
> (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Dave Leach
> INET: Dave.Leach_at_claybrook.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Get your free @yahoo.co.uk address at
http://mail.yahoo.co.uk
or your free @yahoo.ie address at
http://mail.yahoo.ie
Received on Wed Aug 22 2001 - 06:18:50 CDT