The SELECT privilege is a type of table and view level privilege of the GRANT statement.

Syntax

The proper syntax to grant SELECT privileges to a user is:
grant select ON table_name TO username
The following is an example granting SELECT privileges to user John on table pub.customer
grant select on pub.customer to John

You can grant SELECT privileges on a table by table basis. In other words, you cannot grant a user SELECT privileges on all tables in one statement.

For more information, see Database privileges.