Re: Requirements for update languages?

From: David Cressey <david_at_dcressey.com>
Date: Mon, 18 Nov 2002 20:39:00 GMT
Message-ID: <EdcC9.279$0I3.28135_at_petpeeve.ziplink.net>


> Indeed it is not. What I am saying is that the user should be able to see
that
> the statement that actually got executed in his name was.
>
> InvoiceHeader := InvioceHeader MINUS (InvoiceHeader WHERE InvNo =
12345),
> InvoiceItem := InvoiceItem MINUS (InvoiceItem WHERE InvNo = 12345);
>
> even though he only asked the DBMS to do
> DELETE FROM InvoiceHeader WHERE InvNo = 12345;
>
>
> This would then allow our users to be responsible for thier transactions.
If
> they don't know what is being done in their name, why should they feel
> responsible at all?

OK, now I get it. Now I have to think about it.

If I were a user, merely being informed about what was being done in my name would not be enough.
I would want control over whatever I was supposed to "feel responsible for".

But, as someone who has managed databases, I couldn't bring myself to grant that kind of control very easily. Received on Mon Nov 18 2002 - 21:39:00 CET

Original text of this message