Granting the SELECT Privilege on Tables and Views

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.

Prerequisites

Requires one of:

Task

To grant the SELECT privilege, enter:

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

Example:

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