able and view permissions are limited in that they apply to all the data in a table or view (except for the UPDATE permission which may be restricted).
T Finer tuning of user permissions can be accomplished by creating procedures that carry out actions on tables, and then granting users the permission to execute the procedure.
To grant permission to M_Haneef to update the column_1 and column_2 columns only in the table named sample_table:
Type and execute the SQL statement:
GRANT UPDATE (column_1, column_2) ON sample_table TO M_Haneef