Re: change users' default schema

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?

Something like this, perhaps?

create or replace trigger set_default_schema   after logon on myuser.schema
begin

   execute immediate 'alter session set current_schema=scott'; end;
/

-- 
"I'm too sexy for my code." - Awk Sed Fred.
--
http://www.freelists.org/webpage/oracle-l