| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Using TOAD on production databases
Your're right though you actually have to type the command in sqlplus. =
He had selected the wrong tables in the wrong schema and punched the =
button. Sometimes with ease comes risk. At the time, I wasn't worried =
about it all because I had seen the backup for the development database =
on the schedule so I just asked the DBA to restore it and he explained =
to me that just because something was scheduled didn't mean it was being =
done...ever. Having a schedule listing all of the required events is =
almost as good as actually doing them I understand.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Hostetter, Jay M
Sent: Tuesday, August 17, 2004 10:25 AM
To: oracle-l_at_freelists.org
Subject: RE: Using TOAD on production databases
Are you going to disable it in SQL*Plus? It sounds like your developers have some rights that they shouldn't have.
Jay=3D20
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Freeman, Donald
Sent: Tuesday, August 17, 2004 10:20 AM
To: oracle-l_at_freelists.org
Subject: RE: Using TOAD on production databases
I like Toad but you have to be careful. One of our developers used a =
=3D3D
trial version to truncate a number of very important tables in =3D3D
development that weren't backed up on the exact day I submitted the =
=3D3D
purchase order for 20 seats to management. We never got Toad. However,
=3D3D after much research I was able to find that you can disable that
button =3D3D in the config file.=3D3D20
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Scott Canaan
Sent: Monday, August 16, 2004 4:42 PM
To: oracle-l_at_freelists.org
Subject: RE: Using TOAD on production databases
Venu,
Just keep in mind that if the developers have the rights to change any of the data in production, they will be able to do it directly via TOAD. TOAD makes it even easier to make data changes, without SQL.
Scott Canaan (srcdco_at_rit.edu)
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.
**DISCLAIMER
This e-mail message and any files transmitted with it are intended for =
the =3D
use of the individual or entity to which they are addressed and may =
contain=3D
information that is privileged, proprietary and confidential. If you =
are n=3D
ot the intended recipient, you may not use, copy or disclose to anyone =
the =3D
message or any information contained in the message. If you have =
received t=3D
his communication in error, please notify the sender and delete this =
e-mail=3D
message. The contents do not represent the opinion of D&E except to the =
ex=3D
tent that it relates to their official business.
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |