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
For more information about block predicates, see this blog post: New Row-Level Security functionality: Block predicates (preview)