Re: Change default Schema for a user automatically

"Sam" <sasan.raisdana_at_mobidia.com> a écrit dans le message de news: C2JGg.441147$Mn5.340947_at_pd7tw3no...
| Hi There,
| Is there a way that I define , default Schema for a user automatically?
|
| I have some users that login from different software and they have no data
| under their schema,
| but they have some permissions on Tables and Procedures under another user
| schema, I don't
| want them to user Schema. (Prefix) when they call an object (Maintanace
| problam), I know that there is a command
|
| ALTER SESSION SET CURRENT_SCHEMA = [SCHEMA NAME]
|
| But is there a way to change it for a user for ever? is there such a thing
| like "Login Script" for user that I can add this
| command for user to make it run whenever it login to system? (They don't
| login through SQL+, they login from different
| program or Oracle clients).
|
| I use Oracle 10G release 2.0 under widows Server 2003,
|
| Thank you in Advance - Sam
|
|

Search for "after logon" trigger in documentation.

Regards
Michel Cadot Received on Tue Aug 22 2006 - 15:12:52 CDT