alias/synonym on user/schema
This is a discussion on alias/synonym on user/schema within the Oracle Miscellaneous forums, part of the Oracle Database category; --> Hi all, is there a way to have an alias on an oracle user/schema. I want to redirect a ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 11:59 AM
| |||
| |||
 Re: alias/synonym on user/schema "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      |
|
04-08-2008, 11:59 AM
| |||
| |||
| Re: alias/synonym on user/schema 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 |
|
04-08-2008, 11:59 AM
| |||
| |||
| Re: alias/synonym on user/schema 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; / |
|
04-08-2008, 11:59 AM
| ||||
| ||||
| Re: alias/synonym on user/schema "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 |
Linear Mode
