Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: multiple tnsnames.ora files

Re: multiple tnsnames.ora files

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sun, 18 Mar 2001 14:52:00 -0800
Message-ID: <3AB53C10.CA118E06@exesolutions.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!

I recommend not giving away anything for free to crackers and disgruntled employees on their way out the door some Friday afternoon. The TNSNAMES file a user sees should only point to the instance(s) they need to know about.

Daniel A. Morgan Received on Sun Mar 18 2001 - 16:52:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US