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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Deny Read on a table

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 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??

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-03-12 : 12:36:02
Can't deny anything to dbo
Go to Top of Page
   

- Advertisement -