Hi,

Issue the following for each table...

grant select on table_name to user2;

Where table_name is the name of the table you wish user2 to be able to select on.

Cheers

Moff