Granting the UPDATE Privilege on Tables and Views

Grant the privilege to modify the data in a table or view. This privilege can be restricted to a set of columns in the table.

Prerequisites

Requires one of:

You have been granted the MANAGE ANY OBJECT PRIVILEGE system privilege.
You have been granted the UPDATE object privilege on the table with the WITH GRANT OPTION clause.
You own the table.

Task

To grant the UPDATE privilege, enter:

GRANT UPDATE column_name 
  ON table_name
  TO userID [,...]

Example:

This statement grants the UPDATE privilege to user Joe on columns Col_1 and Col_2 in the table named sales_table:

GRANT UPDATE Col_1, Col_2 ON sales_table
TO Joe