[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