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 |
|
Kimi86
Yak Posting Veteran
79 Posts |
 Posted - 2013-03-12 : 09:32:49
|
| I nned to restrict some users from reading a table in my databse.This is what I have done so farUnder databse -> Security-> Roles-> Database Roles -> Right Click to create new database roleIn the property window general tabAdd role name (Deny_read) and Owner(dbo)Schema owned by this role - > I did not select anythingRole Members -> Addeda usernameIn the property window Securables tabSecurables -> added the table namePermissions for the table -> check deny selectBut after creating this Role the user is still able to access the table and perform select on it..Any idea y this could be happening?? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-03-12 : 12:36:02
|
| Can't deny anything to dbo |
 |
|
|
|
|
|
Deny Read on a table