Public preview: Row-Level Security block predicates for SQL Database

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

Free account

Learn and build with $200 in credit, and keep going for free

Start free

Visual Studio

Subscribers get up to $1800 per year of Azure services

Activate now

Startups

Join the BizSpark program and get free Azure services

Learn more