multiple tnsnames.ora files

From: Paul Sheahan <psheahan_at_snet.net>
Date: Thu, 15 Mar 2001 19:59:20 -0800
Message-ID: <F001.002CE74A.20010315195130@fatcity.com>

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: psheahan_at_snet.net

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: ListGuru_at_fatcity.com (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). Received on Thu Mar 15 2001 - 21:59:20 CST