Hi Guys

I have a user database by the name "ONEX" which has the default tablespace "ONEX" and temporary tablespace "TEMP".It has 46 tables, Production database. WIN NT,Oracle 7.3.4.

Now a user wants to Access this database with only Select privilege on all this 46 tables.

1.I will create the user account like (Correct me if i am wrong)

create user <user name> identified by password
default tablespace onex
temporary tablespace temp;

How to grant only select on all the 46 tables to him?

Please let me know as soon as possible.

Thanks in Advance
Ravi