Re: View updating in practice?

From: Ed Prochak <edprochak_at_adelphia.net>
Date: Mon, 11 Nov 2002 23:18:38 GMT
Message-ID: <3DD03D83.9050509@adelphia.net>

Alexander Kuznetsov wrote:
> Hi,
> I'll respectfully disagree.
> We aren't stupid. We were always well aware of this possibility of
> (1=1).
> The solution filters out very simple and very common human error (as I
> said before, 20 some times in my experience ALONE). Also it leaves way
> to say "shut up, I know what I'm doing (1=1)". Also it limits the
> consequences of knowing what I'm doing to my own data (ENTERD_BY =
> CURRENT USER).
no need to get upset about it.

But even with the additional checks you describe, I think it's a bandaid approach. If you really don't trust uses to delete data, do not give them that privilege.

Give them the update privilege so that they can change a status field from active to inactive for instance. Received on Mon Nov 11 2002 - 17:18:38 CST