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: 1960 | Views in the last 30 days: 2
 
Related Articles
ARTICLE

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

BLOG

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

SCRIPT

Security Queries: Server-level

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

ARTICLE

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

BLOG

Row-Level Security in SQL Server and Azure

Row-Level Security (RLS) is a new feature of SQL Server 2016 and Azure SQL Database that enables dat...

 
Contribute