Allowing users to update only specific columns in your tables
You can permit a user to update only certain columns in your tables by qualifying the UPDATE privileges with the names of specific columns.
The following example shows you how to give user LINDSAY the authority to update the LOCATION column in the CALENDAR table:
GRANT UPDATE(LOCATION) ON TABLE CALENDAR TO LINDSAY
This example grants user LINDSAY the authority to change the contents of the LOCATION column in the CALENDAR table.