Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Using TOAD on production databases

RE: Using TOAD on production databases

From: Jesse, Rich <Rich.Jesse_at_quadtechworld.com>
Date: Tue, 17 Aug 2004 13:51:34 -0500
Message-ID: <FBE1FCA40ECAD41180400050DA2BC54004E93C76@qtiexch2.qgraph.com>


Quick thought: Install TOAD on network-only as read-only, then use a logon trigger on production to deny all other versions of TOAD, which now can be done by checking the MODULE column of V$SESSION. There are probably holes there, but it's just a quick thought. Now back to hacking 9.2.0.1 client to actually install (again)...

Rich

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

Sent: Monday, August 16, 2004 6:03 PM
Subject: Re: Using TOAD on production databases

The production issue is one of the main reasons we developed our freeware tool SchemaSurf (the other requirement being web-based). Although it doesn't claim anywhere near-like the industrial strength that Toad has, it does provide developers with read-only access to production data/models. TOAD is a great tool, but with Sarbanes-Oxley, it's critical that appropriate procedures are in place (so we can all go break them!)

SchemaSurf has been installed in more than 50 countries, and we had numerous folks at OAUG shows etc tell us that they use TOAD for dev/test and SchemaSurf for prod. Made their management very happy .... and DBA's were able to control access via tns/name servers etc. since SchemaSurf doesn't use SQL*Net/Net8.

It's at http://www.cobblesoft.com/schemasurf/ for anyone interested.

Regards,

Richard J Stevenson



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 - 13:48:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US