give read only to a db

[terry712]

afraid my sql skills suck

what do i need to give some on read access to a db held on the sql box

if i create a new login and use the pull down db tab
what access right should be ticked - or what is the best method

 

[Jamfool]

The db_datareader role should be fine.

http://msdn2.microsoft.com/en-us/library/ms188629.aspx