Deny select on table Grant select on columns
There is a little warning in books-on-line about the interaction of Deny and Grant (http://msdn.microsoft.com/en-us/library/ms173724.aspx). “A table-level DENY does not take precedence over a column-level GRANT. This inconsistency in the permissions hierarchy has been preserved for backward compatibility.” However, I found a little caveat to this point. The order in which you issue the GRANT and […]
Deny select on table Grant select on columns Read More »