Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: alias/synonym on user/schema

Re: alias/synonym on user/schema

From: Björn Wächter <bwc_at_p3-solutionsKILL_SPAM.de>
Date: Wed, 20 Dec 2006 15:09:18 +0100
Message-ID: <4usugeF19k9btU1@mid.dfncis.de>


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 Received on Wed Dec 20 2006 - 08:09:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US