Grant insert, but only allow entering vals in some fields

I have a table with 3 fields:
val1
val2
val3

Is there a way using a role to allow users to create a new record in
the table, but only allowing them to populate the val1 field during the
insert? They should not be allowed to put data in fields val2 and val3
during the insert and they should only be allowed to modify the val1
field.

Thanks!

Chris

.

Relevant Pages

  • Re: Grant insert, but only allow entering vals in some fields
    ... but only allowing them to populate the val1 field during the ... They should not be allowed to put data in fields val2 and val3 ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: foreach enhancement?
    ... is with finding compatible syntax as ... is legal current syntax that assigns list index 1 ... to the variable name "val1 val2". ...
    (comp.lang.tcl)
  • Re: Index and/or algorithm to search two ranges
    ... although you may still be able to find for Clipper. ... IF the VAL2 range is more restrictive than the VAL1 range, it would obviously come first in the indexing. ...
    (comp.lang.clipper)
  • Re: Compact multiple-value returns
    ... Is there a way of assigning multiple variables to these values in a nice compact way? ... so that a would be set to val1, and b would be set to val2. ... I'm thinking that, as a n00b, knowing so few of the functions, I tend to write Lisp "the hard way" - little realising that the Lisp language designers had already anticipated common needs, and provided it" ...
    (comp.lang.lisp)
  • Re: operations with double integers
    ... It seems that "is val1 minus val2 greater than limit"? ... printed val2 with two decimal digits, would the printed result look as ... calculated, what rounding errors you could have made, and check if the ...
    (comp.lang.c)