Re: how to prevent unwanted deletion

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 22 Feb 2002 02:06:04 -0800
Message-ID: <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.

Sybrand Bakker
Senior Oracle DBA Received on Fri Feb 22 2002 - 11:06:04 CET

This message: [ Message body ]
Next message: Adrian Billington: "Re: Pl/SQL Embed Function within Procedure or other Function?"
Previous message: michael ngong: "Re: Is there a way to determine whether a patch is insalled and it's version?"
In reply to: Ming: "how to prevent unwanted deletion"
In reply to Ming: "how to prevent unwanted deletion"
Next in thread: Adrian Billington: "Re: Pl/SQL Embed Function within Procedure or other Function?"
Reply: Tho Nguyen: "Re: how to prevent unwanted deletion"

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

Original text of this message