Re: Changing the default schema for a user

From: Jan van Mourik <jmourik_at_yahoo.com>
Date: 19 Nov 2003 09:00:48 -0800
Message-ID: <ffe966de.0311190900.bd8c7e4@posting.google.com>

thomaszic_at_hotmail.com (Thomas Lam) wrote in message >
> Therefore, I grant SELECT, INSERT, UPDATE and DELETE of all objects
> under "admin" to "operator" and using the following command when
> "operator" login:
>
> ALTER SESSION SET CURRENT_SCHEMA= admin;
>

create or replace trigger after_logon_operator after logon on operator.schema
begin

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

No need for synonyms in this case!

jan Received on Wed Nov 19 2003 - 11:00:48 CST