Re: change users' default schema

On 11/2/06, Roger Xu <Roger.Xu@xxxxxxxxxxx> 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


Other related posts: