db_datareader - access to all tables/views

will the db_datareader role give an user to able to select all tables and views by default? or not yet?

thanks
LVL 6
anushahannaAsked:
Who is Participating?
 
rg20Connect With a Mentor Commented:
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
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
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
 
anushahannaAuthor Commented:
appreciate your input. Thanks experts.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.