RE: change users' default schema

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Thu, 2 Nov 2006 21:11:23 -0000
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC1663B76B@ENYC11P32005.corpny.csfb.com>

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_at_credit-suisse.com
www.credit-suisse.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Roger Xu Sent: Thursday, November 02, 2006 4:04 PM To: Oracle-L_at_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

---

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 02 2006 - 15:11:23 CST