| 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
The key word is there, "rights". If all they have is select, your safe. =
Now how can toad make it easier, because it's an easier interface. =
Good old SQL*Plus use to be called UFI back in the V3 days, for =
Unfriendly F&&k'n Interface.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Potluri, Venu (IDS AIS SE) [mailto:venu_potluri_at_ml.com]
Sent: Monday, August 16, 2004 6:11 PM
To: oracle-l_at_freelists.org
Subject: RE: Using TOAD on production databases
How can they make the data change if they don't have the privileges. For example, if they don't have update, insert, delete on a table, how can TOAD make it easier for them to change data in production?
-----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=3D3D20
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
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html=3D
-----------------------------------------------------------------=3D20
--------------------------------------------------------
=3D20 If you are not an intended recipient of this e-mail, please notify the =
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
 |
 |