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


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).


立即註冊並取得 $200 的 Azure 點數


Visual Studio

訂閱者每年最多可取得價值達 $1800 的 Azure 服務



加入 BizSpark 方案並取得免費 Azure 服務