How to create Read-Only Database User in SQL Server 2008?

How do you give permission to a database in SQL server to a QA or someone who wants to have read only access?
In SQL server 2008, if you want to give read only access to the database for a person, do the following steps

1. Create a new login which is going to have read only access to the database
Right click and click on New Login


2. Add the users from Active Directory

Adding users to SQL server

3. Click on User Mapping and Select the database which you wan to give read access below Users Mapped to this login:
and select Database Role membership as public and db_datareader

Read Only Access to SQL Database

Above setup will allow the users to have database reader access to SQL server

Published by Aryan Nava

Founder of "BlockchainMind", CTO for two Blockchain startup during 2018, Cloud/DevOps Consultant and Blockchain Trainer

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: