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: Paul Drake <bdbafh_at_gmail.com>
Date: Thu, 2 Nov 2006 16:15:42 -0500
Message-ID: <910046b40611021315p59afd5lf29ab625fabf53c@mail.gmail.com>


On 11/2/06, Roger Xu <Roger.Xu_at_dp7upbg.com> wrote:
>
> Hi List,
>
> 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.
>
> Thanks,
>
> Roger Xu
>

http://www.oracleadvice.com/Tips/logontrigger.htm

Or one could use "execute immediate" instead.

hth.

Pd

This e-mail is intended solely for the person or entity to which it is
> addressed and may contain confidential and/or privileged information. Any
> review, dissemination, copying, printing or other use o
> ____________________________________________________________________
> This email has been scanned for all viruses by the MessageLabs Email
> Security System.
>

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

Original text of this message

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