Re: change users' default schema

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