To Deny Permission or Revoke Permission to a Sp

security-audit
#permissions#security-audit
--to block a permission:
Deny permissionname to loginname

--to take back the permission to a specific login:
revoke permissionname to loginname

--to take back the permission from all the logins which have got their permission from with grant from one to other like l1 > l2> l3:
revoke permissionname to loginname cascade