Create SQL Read Only User

Create User

1. Using Microsoft SQL Server Management Studio, log into your database using a full access account
2. 
3. Expand ‘Security’ then right-click on ‘Logins’.
4. Select ‘New Login’. The new login window will open in a new window.
5. 
6. Under ‘Login name’ enter an appropriate name for the account, for example ‘db1_readonly’
7. Select ‘SQL Server Authentication’
8. Under ‘Password’ and ‘Confirm password’ enter and appropriate password
9. 
10. Select ‘User Mapping’ from the left hand list
11. Under ‘Users mapped to this login’ select the database the user will have access to
12. Under ‘Database role’ elect db_datareader’
13. 
14. Click ‘OK’ to save the changes.