Public preview: Row-Level Security block predicates for SQL Database
Published date: October 12, 2015
Block predicates are now available as a preview enhancement for Row-Level Security on Azure SQL Database. Block predicates address a common point of customer feedback by enabling security policies to prevent users from inserting, updating, and deleting rows that violate the predicate. You can try block predicates today on any SQL Database (V12) server.Common use cases for block predicates include:
- Preventing cross-tenant inserts in multi-tenant databases
- Enforcing granular control over write access to rows of data for different users, including scenarios that require separate access logic for INSERT, UPDATE, and DELETE operations