Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Desparate Oracle Help...
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)comReceived on Tue Nov 06 2001 - 14:37:28 CST
![]() |
![]() |