Re: Drop by accident?

From: Michael B. Allen <miallen_at_eskimo.com>
Date: Thu, 30 May 2002 02:39:05 -0400
Message-ID: <20020530.023905.352118606.1462@eskimo.com>

In article <3CF4FB6E.1B145BFE_at_exesolutions.com>, "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote:

> "Michael B. Allen" wrote:
>

>> How common is it to drop records by accedent? We had ~2000 company
>> records zapped today and no one is fessing up. Is it common that
>> someone could drop records like that and then type commit without
>> realising it?
>>
>> --
>> http://www.eskimo.com/~miallen/c/jus.c

>
> Very.
>
> And the cause is generally one of the following:
>
> 1. Inadequately thought out and enforced access permissions
> 2. Developers/DBAs mucking about where they don't belong

Apparetly someone was using Microsoft Acccess to view records. Another user VNC'd into that workstation and not knowing what they were looking at deleted them by accident.

Mike

> 3. Delete statements with poorly constructed WHERE clauses
>
> For now I would use log miner to find out who, what, why, and when.
>
> Then solve the immediate problem and consider creating an audit trail
> enforced by after delete triggers on tables with critical data.
>
> Daniel Morgan

-- 
http://www.eskimo.com/~miallen/c/jus.c

Received on Thu May 30 2002 - 01:39:05 CDT