Re: Drop by accident?

"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
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 Received on Wed May 29 2002 - 11:01:53 CDT