Re: multiple tnsnames.ora files

Two alternatives

1. Oracle Names - a central repository of legitimate database targets, eliminating need for TNSNAMES other than to find the NAMES repository. (This works like DNS).
2. OiD - Oracle's LDAP, which is free when used to manage Oracle security.

/Hans

Paul wrote:

> 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
Received on Sun Apr 29 2001 - 22:57:31 CDT