Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: View updating in practice?

Re: View updating in practice?

From: Jens Lechtenbörger <lechtej_at_uni-muenster.de>
Date: 11 Nov 2002 09:23:45 +0100
Message-ID: <m27kfkv7ji.fsf@pcwi1068.uni-muenster.de>


"Bob Badour" <bbadour_at_golden.net> writes:

> "Jens Lechtenbörger" <lechtej_at_uni-muenster.de> wrote in message
> news:m265v87zud.fsf_at_pcwi1068.uni-muenster.de...
> > Daniel Morgan <dmorgan_at_exesolutions.com> 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 Received on Mon Nov 11 2002 - 02:23:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US