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

September 20, 2011 — Leave a comment

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

image

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

No Comments

Be the first to start the conversation!

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s