Yak Posting Veteran
Posted - 03/12/2013 : 09:32:49
| I nned to restrict some users from reading a table in my databse.
This is what I have done so far
Under databse -> Security-> Roles-> Database Roles -> Right Click to create new database role
In the property window general tab
Add role name (Deny_read) and Owner(dbo)
Schema owned by this role - > I did not select anything
Role Members -> Addeda username
In the property window Securables tab
Securables -> added the table name
Permissions for the table -> check deny select
But 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??