Ok, this forum is new to me so here goes,

I inherited an access 2 db of 200MB+ and have moved it onto SQL7, the database has 250+ tables with the front end accessing via a single .dbo account. I am by company default required to use Crystal Reports to display the information and have have created a 'read only' account (non dbo) for this purpose as db_datareader but it does not appear to have select rights against any tables.
I am looking for a 'simple' way of allowing select against all the tables.

eg: Grant Select on q4w_data.dbo.cm_hi_wk to [Q4W_Report]

How about Grant Select on q4w_data.dbo.sysobjects to [Q4W_Report]?