I guess its may be little big task to create and run scripts with 'SELECT' Privileges on all of the tables if your database is too big.

If its not big enough, could spend 5 to 10 minutes and create a role READONLY_USER and give all the select tables privileges to that role and assign that role to the user you wanted.

Not sure, your intention was little more simplified task or this is what you wanted....