Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
multipass
Starting Member
1 Post |
 Posted - 2009-10-01 : 07:50:37
|
| 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! |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2009-10-01 : 15:14:02
|
| Create a role, assign the permissions to the role and add the users to that role. |
 |
|
|
|
|
|
How do I give users access to only views?