Hi ,

Can someone tell me how do i grant a Read privilage on all the tables
in a schema X to a different user who is not the owner of the Schema .
I dont want to grant him the Alterin privilage to the user.I just want
the user to read the tables in a schema for which he is not the owner.

I have more than 100 tables with different names. so it is difficult
to give grant select on each table.

Thanks in advance,
Kamalnath.V.