Ready Only Access

Hello,
How do I create a user in a DB and have them Read Only? Is there a QA
script maybe?
TIA
JYou can try adding them to the datareader and denydatawriter roles.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"J Ewing" <nonprivateaddress@.hotmail.com> wrote in message
news:Op7hYSsMEHA.3348@.TK2MSFTNGP09.phx.gbl...
> Hello,
> How do I create a user in a DB and have them Read Only? Is there a QA
> script maybe?
> TIA
> J
>