Re: Prevent update of Non Key fields
From: Gary Gapinski <gapinski_at_lerc.nasa.gov>
Date: 1996/04/17
Message-ID: <4l3ies$hog_at_bytor.lerc.nasa.gov>#1/1
Date: 1996/04/17
Message-ID: <4l3ies$hog_at_bytor.lerc.nasa.gov>#1/1
Updates of primary key and foreign key target columns can be handled using declarative referential intergity, as you have pointed out. Restricting updates of other columns can be handled using discretionary access control. However, given your example, simply avoid granting update access to the table.
Regards,
Gary
-- __________________________________________________________ Gary Gapinski email: Gapinski_at_lerc.nasa.gov NASA Lewis Research Center voice: +1 216 433 5251Received on Wed Apr 17 1996 - 00:00:00 CEST