Read Only User for SQL Server

In order to create a Readonly user to have just Read out of the CRUD operations for DML Statements


1. Open Security->Logins
2. Right Click the User and choose Properties
3. Click User Mapping
4. On the Database list select the database the user is going to get associated with (Note in SQL Server 2005 the title of this panel is wrongly given as "Users Mapped to this login" instead of "Databases Mapped to this login"
5. On the bottom select the following permissions

• db_datareader


• db_denydatawriter