Row-Level Security is designed to allow DBAs to implement preficate based access control. Using functions, administrators can limit which rows a user can query.
Here are a list of links that might help you learn more. Note that many of these are links to other sites and we cannot guarantee they still work. We also should note that some of these, especially Books Online, may change over time.
If you find broken links or think we should have more here, please leave a comment in the discussion for this article.
- Books Online - Row-Level Security
- Announcing Row-Level Security in Azure SQL Database
- SQL Server 2016 Row Level Security (Channel 9 Video)
- SQL Server Row Level Security Example
- Introduction to Row Level Security in SQL 2016
- How to Setup Row Level Security for SQL Server
“Have you started using Row Level Security (RLS) yet? If so, you’ll need a safe and reliable way of migrating any RLS changes from one database to the next. The good news is Redgate SQL Compare, the industry standard for comparing and deploying SQL Server databases, supports RLS. Data Platform MVP Steve Jones explores exactly how this works in Using SQL Compare with Row Level Security.” |
Continue learning more about SQL Server
View the index of features for the various versions.