Looking into DENY and GRANT security permissions
In this post I would like to talk about DENY and GRANT security permissions. I will provide some examples that will demonstrate that DENY takes precedence over GRANT but there are some special cases.
We use DENY and GRANT T-Sql commands to give permissions on a securable (e.g table) to a principal (a custom user we have created).Most developers are familiar with their use but there are some special cases I would like to point out. (
read more)