Re: how to prevent unwanted deletion

From: Tho Nguyen <tho_pic_at_yahoo.com>
Date: 27 Feb 2002 00:02:10 -0800
Message-ID: <d177c6d9.0202270002.7c999b23_at_posting.google.com>

postbus_at_sybrandb.demon.nl (Sybrand Bakker) wrote in message news:<a20d28ee.0202220206.17416f6d_at_posting.google.com>...
> mliu007us_at_yahoo.com (Ming) wrote in message news:<4865d4fd.0202211343.2614c649_at_posting.google.com>...
> > Hi,
> > How can I write a trigger to prevent unwanted deletion based on
> > certain conditions, e.g. age>60?
> > Thanks.
> > Ming
>
> Create a view with the conditions, grant delete access only to the view.
>
> Regards
>
> Sybrand Bakker
> Senior Oracle DBA

I've tried it but not successfully. When i delete from view the data in table is deleted as well.
Could you give out an example? Received on Wed Feb 27 2002 - 09:02:10 CET

This message: [ Message body ]
Next message: catherinedevlin_at_removethispart.toast.net: "Re: Another query question.."
Previous message: Christian Walter: "Re: HELP with replication for Oracle Lite to Oracle server"
Maybe in reply to: Ming: "how to prevent unwanted deletion"
In reply to Sybrand Bakker: "Re: how to prevent unwanted deletion"
Next in thread: catherinedevlin_at_removethispart.toast.net: "Re: Another query question.."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message