Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!cyclone2.usenetserver.com!news.webusenet.com!newsfeed1.cidera.com!Cidera!radon.golden.net!not-for-mail From: "Bob Badour" Newsgroups: comp.databases.theory,comp.databases.oracle.misc References: <3DCBE7A4.1D532340@exesolutions.com> Subject: Re: View updating in practice? Lines: 31 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-Mimeole: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: Date: Mon, 11 Nov 2002 12:47:57 -0500 NNTP-Posting-Host: 207.35.144.84 X-Complaints-To: abuse@golden.net X-Trace: radon.golden.net 1037037062 207.35.144.84 (Mon, 11 Nov 2002 12:51:02 EST) NNTP-Posting-Date: Mon, 11 Nov 2002 12:51:02 EST Organization: Golden Triangle On Line Inc. Xref: newsfeed1.easynews.com comp.databases.theory:23561 comp.databases.oracle.misc:89212 X-Received-Date: Mon, 11 Nov 2002 10:50:47 MST (news.easynews.com) "Jens Lechtenbörger" wrote in message news:m27kfkv7ji.fsf@pcwi1068.uni-muenster.de... > "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. You are ignoring the role of the data modeller. Do you likewise wish to prohibit cascaded deletes? > > Jens