RE: change users' default schema

  • From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
  • To: "'Roger.Xu@xxxxxxxxxxx'" <Roger.Xu@xxxxxxxxxxx>, "Oracle-L@Freelists. Org (E-mail)" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 2 Nov 2006 21:11:23 -0000

you can create a login trigger for that user that does
 
execute immediate 'alter session set current_schema=''SCOTT''';
 
 

Paul Baumgartel 
CREDIT SUISSE 
Information Technology 
DBA & Admin - NY, KIGA 1 
11 Madison Avenue 
New York, NY 10010 
USA 
Phone 212.538.1143 
paul.baumgartel@xxxxxxxxxxxxxxxxx 
www.credit-suisse.com 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On 
Behalf Of Roger Xu
Sent: Thursday, November 02, 2006 4:04 PM
To: Oracle-L@Freelists. Org (E-mail)
Subject: change users' default schema


Hi List,
 
Can I change a user's default schema, so he dose not need to type SCOTT.EMP 
just EMP?
(This user does nothing but queries SCOTT's tables.)
I know "Synonyms" can be created to bypass the prefix requirement.
 
Thanks,
Roger Xu   


This e-mail is intended solely for the person or entity to which it is 
addressed and may contain confidential and/or privileged information. Any 
review, dissemination, copying, printing or other use o
____________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email Security 
System.



==============================================================================
Please access the attached hyperlink for an important electronic communications 
disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================

Other related posts: