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