Re: trigger problem

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Fri, 15 Apr 2005 16:31:38 -0700
Message-ID: <1113607675.213448@yasure>

Sybrand Bakker wrote:

> On Fri, 15 Apr 2005 10:01:38 -0700, DA Morgan
> <damorgan_at_x.washington.edu> wrote:
>
>

>>I would personally ban, from almost any prouduction environment, TOAD,
>>SQL*Plus, SQL*Navigator, MS Access, and any other tool that is not an
>>approved and tested application front-end that will prevent mistakes
>>such as UPDATE, DELETE, TRUNCATE, ALTER, and DROP.

>
>
> Databases with proper constraints don't need such a ridiculous
> measure.
> You don't say your database have no constraints, do you?
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

Build any constraint you wish and see if you can prevent me from logging on with a developer tool and issuing the above with constraints: You can't.

You can with DDL and table triggers but that is a different conversation. In a production environment, at least here in the U.S. and under Sarbanes-Oxley legal restrictions, no one should ever use any of these tools in a production environment unless they are a masochist.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Fri Apr 15 2005 - 18:31:38 CDT