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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: change users' default schema

Re: change users' default schema

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 2 Nov 2006 13:12:08 -0800
Message-ID: <bf46380611021312u6df953a7g34c77055f5384f08@mail.gmail.com>


On 11/2/06, Roger Xu <Roger.Xu_at_dp7upbg.com> wrote:
>
> Can I change a user's default schema, so he dose not need to type
> SCOTT.EMP just EMP?
> (This user does nothing but queries SCOTT's tables.)
> I know "Synonyms" can be created to bypass the prefix requirement.
>
>

alter session set current_schema = scott;

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 02 2006 - 15:12:08 CST

Original text of this message

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