Re: Question: Use Trigger to Prevent Deletes with no Where Clause?

On Thu, 13 Jan 2005 11:24:28 -0800, Jesse wrote:

> Hi all. We recently discovered a bug in one of our applications (it's
> in Visual Basic; we inherited it) that under an obscure set of
> conditions executes a "DELETE FROM [table]" without a where clause. We
> can fix the app, but getting it certified for use takes time; however,
> I can make various administrative changes to the database however
> without approval.
>
> My question is, can I use a "before" trigger to detect the mass "DELETE
> FROM" statement and prevent it from executing?
>

Version? Edition? other useful information besides 'help!'

I'm thinking a trick using VPD's rewrite capability below 10g, or the 10g rewrite capability might save you temporaarily. Haven't thought it through since I don't knpw what might be relevant.

FGB Received on Thu Jan 13 2005 - 13:46:13 CST