How can I grant only select permission to a given role for all tables in a given database?

If I have to write code to accomplish this, can that be done in a stored procedure? I tried using sp_tables() but do not know how to loop through the result in TSQL. Any idea?

Thanks in advance