Home > IT Answers > Microsoft Windows > SQL 2008 Security: How do I give users access to just views within a DB?
Multipass
5 pts.
 SQL 2008 Security: How do I give users access to just views within a DB?
Microsoft Excel, SQL, SQL 2008
[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: October 1, 2009  5:19 PM
UPDATED: October 3, 2009  11:43 PM
RELATED QUESTIONS
Answer Wiki:
You'll want to create a roll, and give the role access to the views. Then make the users members of the role.
Last Wiki Answer Submitted:  October 3, 2009  11:43 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _