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 |
|
homeguard
Starting Member
32 Posts |
 Posted - 2008-05-01 : 16:10:05
|
| I have a database with two views in it. As it is right now i have two sql logins one for readers and one for modifiers. I need to open the database up to windows auth. I want users to only be able to see views and not the tables. I also want users to be able to modify the table if they are in one view but not in the other views. How would i do this? I have limited experience with permissions like this. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-01 : 16:29:47
|
| Create two roles in your database. Grant permissions to the roles based upon your requirements. Add windows accounts or groups to the roles.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
homeguard
Starting Member
32 Posts |
Posted - 2008-05-01 : 17:55:36
|
| so one role would have modify access to the one view that can modify.The other role would only have read access to the other views.and i just need to add in my domain group? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-01 : 18:16:12
|
| Yes. But make sure your domain groups have the correct users in it. In order to get the security how you want it, you'll need a minimum of two Windows groups, one for each role.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
|
|
|
Views Security and Permissions