Solved

db_datareader - access to all tables/views

Posted on 2010-08-24
3
656 Views
Last Modified: 2012-05-10
will the db_datareader role give an user to able to select all tables and views by default? or not yet?

thanks
0
Comment
Question by:anushahanna
3 Comments
 
LVL 9

Accepted Solution

by:
rg20 earned 250 total points
ID: 33517258
Anushahanna,

If you are looking for different opinions, I salute you, but please let me know so I don't keep injecting in your questions.

The way this works is you create a new database user.  This user will have to be granted the right to read the view by you.  

Once you grant that right, they will be able to query ONLY the view you specify.

try this link
http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic6253.aspx
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 250 total points
ID: 33517324
yes, db_datareader role gives SELECT rights to all Tables and views by default.
Or in other words, granting db_datareader role implicitly grants SELECT rights on tables and views.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 33517566
appreciate your input. Thanks experts.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Error in WHERE Clause 5 42
SQL Query resolving a string conversion issue 26 39
SSRS troubles 4 20
SQL won't work after disabling SSL3 / TLS1 3 13
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now