Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!news-lei1.dfn.de!news-koe1.dfn.de!uni-muenster.de!not-for-mail From: "Jens =?iso-8859-15?q?Lechtenb=F6rger?=" Newsgroups: comp.databases.theory,comp.databases.oracle.misc Subject: Re: View updating in practice? Date: 11 Nov 2002 09:23:45 +0100 Organization: Westfaelische Wilhelms-Universitaet Muenster, Germany Lines: 21 Sender: "Jens Lechtenboerger" Message-ID: References: <3DCBE7A4.1D532340@exesolutions.com> NNTP-Posting-Host: localhost.uni-muenster.de Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Trace: redenix.uni-muenster.de 1037003035 26978 127.0.0.1 (11 Nov 2002 08:23:55 GMT) X-Complaints-To: abuse@uni-muenster.de NNTP-Posting-Date: 11 Nov 2002 08:23:55 GMT User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.1 Xref: newsfeed1.easynews.com comp.databases.theory:23525 comp.databases.oracle.misc:89194 X-Received-Date: Mon, 11 Nov 2002 02:09:37 MST (news.easynews.com) "Bob Badour" writes: > "Jens Lechtenbörger" wrote in message > news:m265v87zud.fsf@pcwi1068.uni-muenster.de... > > Daniel Morgan writes: > > > [snip] > > The question is the following: How dangerous are clueless users? If > > view updates are triggered from applications, then the application > > designer hopefully guarantees that the right things happen. If > > users access the database via SQL, they might delete valuable data. > > How dangerous? Very. However, I do not see the difference between a clueless > user deleting valuable data from a base table and a clueless user deleting > valuable data from a view. I see this as an issue for the dbms' security > function. My point is the following: With views, even users with a clue might not have a chance to understand their actions. Jens