SQL 2008 Security: How do I give users access to just views within a DB?
Home > IT Answers > SQL Server > SQL 2008 Security: How do I give users access...
Multipass
5 pts.
0
Q:
SQL 2008 Security: How do I give users access to just views within a DB?
SQL 2008, SQL, Microsoft Excel
[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
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
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
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0