Problems with triggers
From: Wendy Cooper <cooper_at_cimage.com>
Date: 1995/04/24
Message-ID: <3nh8ll$lir_at_dgsi.cimage.com>#1/1
Date: 1995/04/24
Message-ID: <3nh8ll$lir_at_dgsi.cimage.com>#1/1
[ Article crossposted from comp.databases.oracle ] [ Author was Steve Butler ] [ Posted on Thu, 20 Apr 1995 09:09:33 -0700 ]
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 Mon Apr 24 1995 - 00:00:00 CEST