Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed-east.nntpserver.com!nntpserver.com!router2.news.adelphia.net!news2.news.adelphia.net.POSTED!not-for-mail Message-ID: <3DD03D83.9050509@adelphia.net> From: Ed Prochak User-Agent: Mozilla/5.0 (Windows; U; Win98; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0 X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.theory,comp.databases.ibm-db2,comp.databases.ms-sqlserver,comp.databases.oracle.misc Subject: Re: View updating in practice? References: <3DCEC92B.9090101@adelphia.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 20 Date: Mon, 11 Nov 2002 23:18:38 GMT NNTP-Posting-Host: 24.53.27.195 X-Complaints-To: abuse@adelphia.net X-Trace: news2.news.adelphia.net 1037056718 24.53.27.195 (Mon, 11 Nov 2002 18:18:38 EST) NNTP-Posting-Date: Mon, 11 Nov 2002 18:18:38 EST Xref: newsfeed1.easynews.com comp.databases.theory:23588 comp.databases.ibm-db2:69333 comp.databases.ms-sqlserver:81022 comp.databases.oracle.misc:89231 X-Received-Date: Mon, 11 Nov 2002 16:19:44 MST (news.easynews.com) 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.