Re: alias/synonym on user/schema

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 20 Dec 2006 16:35:57 +0100
Message-ID: <4589585d$0$16991$426a34cc@news.free.fr>

"Björn Wächter" <bwc_at_p3-solutionsKILL_SPAM.de> a écrit dans le message de news: 4ut1jhF19pl2mU1_at_mid.dfncis.de...
| Björn Wächter wrote:
| > Michel Cadot wrote:
| >> "Björn Wächter" <bwc_at_p3-solutionsKILL_SPAM.de> a écrit dans le message de news: 4ushsvF19h3ehU1_at_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 Received on Wed Dec 20 2006 - 09:35:57 CST