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.

Microsoft announced that its SQL Database now supports row level security (RLS). RLS lets administrators provide row-level access to data based on a user's identity or role. The company released the ...

Row-level security and column masking features in Azure SQL are meant to go beyond protecting data at rest ...

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

Row-level security, master data management, data lineage and other "governance" features may not be super-exciting, but they are super-important.

Coming up to speed with other database management systems and Microsoft's own SQL Azure, row level security is now available in SQL Server.