SQL Server Read Only Permissions

I need to GRANT Read only Pe开发者_如何学JAVArmission on few Databases. How Can I achieve this in SQL Server 2005 ?

---

Grant the user(s) the datareader role

exec *THE_DATABASE_NAME*..sp_addrolemember @rolename='db_datareader', membername='*THE_USERNAME*'

---

A quick google search turns up plenty of answers.

such as this one...

But this question probably belongs on ServerFault.com