Grant the privilege to select data in a table or view, but not to alter it. This privilege can be restricted to a set of columns in the table.
Requires one of:
GRANT SELECT column_name ON table_name TO userID [,...]
This statement grants the SELECT privilege to user Joe on columns Col_1 and Col_2 in the table named sales_table:
GRANT SELECT Col_1, Col_2 ON sales_table TO Joe