Re: change users' default schema

From: "Greg Norris" <spikey.mcmarbles@xxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 2 Nov 2006 15:15:25 -0600

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

References:

change users' default schema
From: Roger Xu

Other related posts:

Browse oracle-l