tag:blogger.com,1999:blog-8884584404576003487.post4454120149579002440..comments2015-03-31T17:45:02.311-04:00Comments on ORACLENERD: Managing Database Entries (tnsnames.ora)chet justicehttps://plus.google.com/106910392693696947072noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-8884584404576003487.post-89538979898459545942011-07-27T01:27:45.807-04:002011-07-27T01:27:45.807-04:00@martin
I&#39;m all for segregation at the lowest...@martin<br /><br />I&#39;m all for segregation at the lowest possible level. <br /><br />I&#39;m a developer but I don&#39;t want this kind of responsibility...thankfully the installation (Informatica in this case) was relatively simple and we&#39;re just getting started...<br /><br />It&#39;s just frustrating. I want, no I need to be protected from myself. I&#39;m a dangerous individual! :)oraclenerdhttp://www.blogger.com/profile/12412013306950057961noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-87284450516542351522011-07-27T01:12:59.504-04:002011-07-27T01:12:59.504-04:00Can you somehow separate the different systems so ...Can you somehow separate the different systems so the connection can not be established at all? <br />Depending on your possibilities something like firewalls (if DBs are on different hosts in other subnet), sqlnet.ora - <a href="http://download.oracle.com/docs/cd/B19306_01/network.102/b14213/sqlnet.htm#sthref575" rel="nofollow">TCP.INVITED_NODES</a> or even logon-trigger can do so. <br />By arguing for such things, I&#39;m always the bad DBA which does not gives the develoopers the flexibility they would like to have; You just showed sometimes they must be saved from themself.Martin Bergerhttp://www.blogger.com/profile/16504572924713610305noreply@blogger.com