General availability: Row-Level Security for SQL Database
Published date: August 19, 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