I have seen many articles on maintaining multiple tnsnames.ora files so that individual groups can use each file which only points to the databases they need to see. This seems like a great idea. Why give a global file I wanted to see if others out there are doing this and does it work? Some say it is not easy to manage but I say "would you rather risk someone breaking into the database because you made a global file available that tells everyone how to find all of your databases?" Does anyone NOT recommend this? Any ideas welcome! Thanks, Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Sheahan INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).