SQL 2008 Security: How do I give users access to just views within a DB?
5 pts.
0
Q:
SQL 2008 Security: How do I give users access to just views within a DB?
[h1 class="subject"> [/h1]
I have inherited a SQL DB and need to give a group of users access to some views within a DB. We do not want them to access the tables, just the views. They will be connecting using MS Excel for reporting purposes. Do I use a role or schema? What is the best practice to accompish this task without risking security? Thanks!


Software/Hardware used:
SQL 2008
ASKED: Oct 1 2009  5:19 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
46690 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
You'll want to create a roll, and give the role access to the views. Then make the users members of the role.
Last Answered: Oct 3 2009  11:43 PM GMT by Mrdenny   46690 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0