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.

Procedure

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.