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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Desparate Oracle Help...

Re: Desparate Oracle Help...

From: Christopher Burke <craznar_at_hotmail.com>
Date: Tue, 06 Nov 2001 20:37:28 GMT
Message-ID: <Xns9152435D55D2Ecburkecraznarcom@61.9.128.12>


Thomas Kyte <tkyte_at_us.oracle.com> wrote in news:9s8pjt01b6p_at_drn.newsguy.com:

> when logged in as BOB issue:
>
> SQL> alter session set current_schema = joe;
> SQL> select * from blah;
>
> that'll be as if they entered select * from joe.blah.

Sounds good - but how do I make 'joe' the default schema (as this is running from an APP which I have no control over).

-- 
---
/* Christopher Burke - Spam Mail to craznar_at_hotmail.com
|* www.craznar.com - International Internet Writing Experiment
\* Real mail to cburke(at)craznar(dot)com
Received on Tue Nov 06 2001 - 14:37:28 CST

Original text of this message

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