Make columns read only
From: Ninja Li <nickli2000_at_gmail.com>
Date: Sat, 6 Nov 2010 10:14:46 -0700 (PDT)
Message-ID: <2fe1f26e-3c70-4091-8fb0-737a791b4b6f_at_n30g2000vbb.googlegroups.com>
Hi,
Date: Sat, 6 Nov 2010 10:14:46 -0700 (PDT)
Message-ID: <2fe1f26e-3c70-4091-8fb0-737a791b4b6f_at_n30g2000vbb.googlegroups.com>
Hi,
I would like to make certain columns in an Oracle table read only to prevent anyone from updating the values in these columns. I can think of creating trigger to issue error message whenever update occurs.
Are there better ways to do that? Your suggestions are appreciated.
Nick Li Received on Sat Nov 06 2010 - 12:14:46 CDT