SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Learning Row-Level Security

By Site Owners,

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.

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

Total article views: 1999 | Views in the last 30 days: 3
Related Articles

Stairway to SQL Server Security Level 10: Row-Level Security

Unlike some other industrial-strength database servers, SQL Server lacks a built-in mechanism for pr...


Deploying Row Level Security with SQL Compare

Row Level Security (RLS) is a great new feature in SQL Server 2016. It’s been in Azure SQL Databases...


An Introduction: Level 1 of the Stairway to Row-Level Security

Learn the basics of how Row-Level Security works in SQL Server.


Security Queries: Server-level

A set of queries which attempt to gather as much security-related information on a server instance a...


Stairway to SQL Server Security Level 11: Auditing

By defining server- and database-level audits, you can record just about any kind of event that occu...