Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: alias/synonym on user/schema
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
![]() |
![]() |