select distinct 'grant select on ' + user_name + '.' + name + ' to username go' command from sysobjects
inner join SYSUSER on SYSUSER.user_id = sysobjects.uid
where
type in ('U' ,'V')
and
user_name='database_name'
Just copy and paste the results into a command line session.