"Björn Wächter" <bwc@p3-solutionsKILL_SPAM.de> a écrit dans le message de news: 4ut1jhF19pl2mU1@mid.dfncis.de...
| 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;
| /

You get it.

Regards
Michel Cadot