Re: Make columns read only
From: Volker Borchert <v_borchert_at_despammed.com>
Date: 6 Nov 2010 23:12:21 GMT
Message-ID: <ib4ncl$hrf$1_at_Gaia.teknon.de>
ddf wrote:
> On Nov 6, 1:14 pm, Ninja Li <nickli2..._at_gmail.com> wrote:
> > 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.
Date: 6 Nov 2010 23:12:21 GMT
Message-ID: <ib4ncl$hrf$1_at_Gaia.teknon.de>
ddf wrote:
> On Nov 6, 1:14 pm, Ninja Li <nickli2..._at_gmail.com> wrote:
> > 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.
> I don't know of any; if you're using 10.2.0.x you could create a read-
> only materialized view and if you're using 11.2 you can make the table
> read only.
Is it possible to create two views, a read-only one containing the read-only columns and a writeable one containing the writeable columms, and "concatenating" these into a third one?
-- "I'm a doctor, not a mechanic." Dr Leonard McCoy <mccoy_at_ncc1701.starfleet.fed> "I'm a mechanic, not a doctor." Volker Borchert <v_borchert_at_despammed.com>Received on Sat Nov 06 2010 - 18:12:21 CDT