Viewing 3 posts - 1 through 3 (of 3 total)
when you use deny VIEW DEFINITION the user cannot see the objects but user can still query(select * from table/view) object if they know the name(s). Again I am...
March 15, 2012 at 1:10 pm
#1460107
I created a role and am applying the deny select and deny exec for stored proc to that role, not changing the public access. I am not trying to...
March 15, 2012 at 1:08 pm
#1460104
Well it is 2012 March and I am using SQL Server 2008 R2 and having the same problems SQL S 2005 folks 3 yrs ago had. Anyone come across...
March 15, 2012 at 11:53 am
#1460066