With SQL Server 2016, that is no longer a problem. Implementation Row-Level Security in SQL Server 2016 (and SQL Azure) is based on a specially crafted inline table valued function.

In-Depth Top 7 Features Coming to SQL Server 2016 SQL 2016 has a number of major enhancements which will help whether or not you are implementing on-prem, in Azure or in a hybrid model. By Joey D ...

In addition to StretchDB and AlwaysEncrypted, there are two more exciting features in the works for SQL Server 2016: dynamic data masking and row-level security. In the case of these two features, ...

From in-database analytics to mobile reports, view the Microsoft SQL Server 2019 functions and features that deliver breakthrough performance for your data platform.