On Fri, Jul 11, 2003 at 10:43:38 +0530,
HK <harikrishnan@midascomm.com> wrote:
> 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??
Then things are harder. One way to do this is to use the rule system
to make an updatable view (that won't let you change the one column).
You can also probably do it with before triggers.
