SSAS 2016 Tabular On Premise with Row-Level Security and Active Directory

SSAS 2016 Tabular On Premise with Row-Level Security and Active Directory This is a series of articles related to RLS (Row Level Security), started with http://hectorv.com/bringing-security-where-data-lives We are going to implement RLS (Row-Level Security) in SSAS (SQL Server Analysis Services) Tabular mode. In our use case: Adventure Works Internet Sales, the goal is to restrict access 

Continue Reading…

SQL Server 2016 On-Premise with Row-Level Security with Active Directory (Part I)

In this article, I’ll explain a basic use case of Row-Level-Security implementation for Microsoft SQL Server 2016 database. The AdventureWorks Database supports a fictitious, multinational manufacturing company called Adventure Works Cycles. This company sells products around the world. Sales are ordered from five different countries like Unites States, Germany, United Kingdom, Canada, France and Australia. 

Continue Reading…