So you want to grant select permissions on all tables and views in a given schema to a given user or role?  It isn’t as easy as it is in SQL Server, but it can be done in a relatively simple procedure.  In the code below I created the procedure in the SYSTEM schema since that seemed to be the most logical place, but you could change that to any user.

Click here to open the script shown below as a text file in a new browser window (for easy copy/paste).