RE: DBLINKs in critical production system
- From: "Thotangare, Ajay \(GTI\)" <Ajay_Thotangare@xxxxxx>
- To: "Mitchell, Travis" <Travis.Mitchell@xxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 30 Apr 2007 12:01:18 -0400
Yes I agree with your explanation. How different it is accessing data
from db link and direct connection without dblink considering I have a
very good separate IP/card for dblink
regards,
Ajay
_____
From: Mitchell, Travis [mailto:Travis.Mitchell@xxxxxxxxxxxxxxxx]
Sent: Monday, April 30, 2007 11:03 AM
To: Thotangare, Ajay (GTI); oracle-l@xxxxxxxxxxxxx
Subject: RE: DBLINKs in critical production system
Imagine sticking a post-it with username/password information on your
monitor... db_links are just about the same, especially pre-10g because
the passwords are not encrypted.
I've walked in and found that my database is hung because I did a
developer a favor so they could quickly pull some data from a production
system. Their sql took forever, backup software tried to shutdown the
development database but couldn't because of said sql, ORA-600s and some
relationship building with Oracle support ensued. This was pre audit
everything requirements, so I would recommend that if you have to use
them, make sure your security team and the business has it approved in
writing. Technically they can cause problems but from a security
standpoint you can be heavily exposed.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Thotangare, Ajay
(GTI)
Sent: Monday, April 30, 2007 10:43 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: DBLINKs in critical production system
Hi Group,
I have a question about dblink. I always hear that
- dblinks are not good in production system.
- dblink , ohh!! not in critical production system
- dblink are not safe
Can anybody please let me know the reason for such comments on dblinks.
regards,
Ajay
_____
If you are not an intended recipient of this e-mail, please notify the
sender, delete it and do not read, act upon, print, disclose, copy,
retain or redistribute it. Click here <http://www.ml.com/email_terms/>
for important additional terms relating to this e-mail.
http://www.ml.com/email_terms/
_____
Other related posts:
