General availability: Row-Level Security for SQL Database

19 August 2015

Row-Level Security for SQL Database enables you to store data for many users in a single database and table, while at the same time restricting row-level access, based on a user's identity, role, or execution context. Row-Level Security centralizes access logic within the database, which simplifies and reduces the risk of error in your application code. Row-Level Security can help customers develop secure applications for a variety of scenarios, for instance:
  • Restrict access to financial data, based on an employee's region and role
  • Ensure that tenants of a multi-tenant application can access only their rows of data
  • Enable different analysts to report on different subsets of data, based on their position
Row-Level Security can be configured and maintained by using familiar developer tools such as SQL Server Management Studio or SQL Server Data Tools in Visual Studio. To learn more, please visit the Row-Level Security documentation page.

Free account

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

Start for free

Visual Studio

Subscribers get up to $1800 per year of Azure services

Activate now

Start-ups

Join the BizSpark programme and get free Azure services

Learn more