RE: Using TOAD on production databases

From: Freeman, Donald <dofreeman_at_state.pa.us>
Date: Tue, 17 Aug 2004 10:20:07 -0400
Message-ID: <AFF54B073FF15849B53E32E67EE860760144F019@enhbgpri11.backup>

I like Toad but you have to be careful. One of our developers used a = trial version to truncate a number of very important tables in = development that weren't backed up on the exact day I submitted the = purchase order for 20 seats to management. We never got Toad. However, = after much research I was able to find that you can disable that button = in the config file.=20

-----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.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Potluri, Venu (IDS AIS SE)
Sent: Monday, August 16, 2004 4:24 PM
To: oracle-l_at_freelists.org
Subject: Using TOAD on production databases

Is there any problem with developers using Quest Software's TOAD on production databases? Regardless of the functionality in TOAD, a developer shouldn't be able to use the DBA functionality in TOAD, correct? We grant roles to developers and those roles never include any privilesges on SYSTEM or SYS owned objects. What made me ask this question is a script on www.orafaq.com that shows a way to prevent developers from using TOAD on production databases. Any thoughts are appreciated.

Venu Potluri
Oracle Financials DBA=3D20

=3D20
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 for important additional terms relating to this e-mail. http://www.ml.com/email_terms/=3D20

=3D20

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Tue Aug 17 2004 - 09:16:17 CDT