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 ==============================================================================