Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 680
  • Last Modified:

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
0
anushahanna
Asked:
anushahanna
2 Solutions
 
rg20Commented:
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 RSQL 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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now