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


Other related posts: