Re: Dont allow updation for few columns in a record.

hi all,
thanx bruno.
If we dont grant update access to the table, i will not be able to do any
updations.
I only want to prevent a particular column from being updated.
Is there any way??
TIA.

On Wed, 9 Jul 2003, Bruno Wolff III wrote:

> On Wed, Jul 09, 2003 at 11:40:24 +0530,
>   HK <harikrishnan@midascomm.com> wrote:
> > Hi all,
> >     Is it possible to say that once a record is inserted into the
> > table, nobody can update some particular columns in that record.
> >
> > (eg)
> > table
> > ------
> > prod_id prod_name prod_desc
> >   1      name1      desc1
> >   2      name2      desc2
> >
> > In this table i dont want to allow updation of the prod_name column.
> >
> > I can write a trigger to do this job, but is there any way to specify
> > during the table creation time itself that these columns cannot be
> > altered.
>
> One option would be not to grant UPDATE access to the table.
>

--
regards,
hari
      __
     / /    __  _  _  _  _ __  __         -o)
    / /__  / / / \\// //_// \\ \\/ /         /\\\\  Making things happen
   /____/ /_/ /_/\\/ /___/  /_/\\_\\        _\\_v-

-------------------------------------------------------------------