Re: Drop by accident?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 30 May 2002 10:07:19 +1000
Message-ID: <7beJ8.710$Hj3.2579@newsfeeds.bigpond.com>

I don't know if this is story is true or not but it's kind of cute.

A DBA received an anxious phone call from a distraught user who wrote a delete statement that had an incorrect where condition and deleted half the table instead of the few rows expected.

"I can't see them, they're gone" the user wailed.

"Have you issued a commit" ? asked the DBA, thinking and hoping all is not lost.

After a couple of moments the user replied, "I hadn't, but I have now and I still can't see the rows" !!

Lack of security, lack of training and lack of common sense makes your scenario all too common.

Regards

Richard
"Michael B. Allen" <miallen_at_eskimo.com> wrote in message news:20020529.032407.165344818.2528_at_eskimo.com...
> 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
Received on Wed May 29 2002 - 19:07:19 CDT