Björn Wächter wrote:
> Michel Cadot wrote:
>> "Björn Wächter" <bwc@p3-solutionsKILL_SPAM.de> a écrit dans le message de news: 4ushsvF19h3ehU1@mid.dfncis.de...
>> | Hi all,
>> |
>> | is there a way to have an alias on an oracle user/schema.
>> | I want to redirect a user that is logging into the DB with
>> | the same user name password every time, into a different
>> | schema. Any Ideas?
>> |
>> | Thanks Björn
>>
>> alter session set current_schema ...
>>
>> Regards
>> Michel Cadot
>>
>>
> Is there a way to execute the "alter session" command for
> the user every time he logs in. So that I can change the
> current_schema without any changes on the client code.
>
> Björn


CREATE OR REPLACE TRIGGER ON_LOGON
AFTER LOGON
ON DATABASE
DECLARE

BEGIN

EXECUTE IMMEDIATE 'ALTER SESSION SET CURRENT_SCHEMA = DEVELOP';

END;
/