Re: Problems with triggers

From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1995/04/20
Message-ID: <Pine.SUN.3.91.950420090733.17331A-100000_at_seatimes>#1/1

On 19 Apr 1995, Frederic Lesieur wrote:
> I want this user to be able to update the table in the case where
> a table's field called TYPE is not equal to 'S'. Otherwise, if ='S',
> then Oracle should send a error message saying that the update
> of the table is impossible.

Why not set up a single table view with the restriction that TYPE<>'S'. Then give the user access to the VIEW rather than the table.

+----------------------------------------------------+
| Steve Butler          Voice:  206-464-2998         |
| The Seattle Times       Fax:  206-382-8898         |
| PO Box 70          Internet:  sbut-is_at_seatimes.com |
| Seattle, WA 98111    Packet:  KG7JE_at_N6EQZ.WA       |
+----------------------------------------------------+

All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Thu Apr 20 1995 - 00:00:00 CEST