Is it possible to add row level security in fabric warehouse

[AdamMichael]

I want to implement row level security for users is it possible in warehouse and how it works and how can I implement this in fabric

[v-aatheeque]

Hi @AdamMichael 

Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.

[v-aatheeque]

Hi @AdamMichael 

We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.

[svenchio · Accepted solution]

Hi @AdamMichael , the answer to your question is is YES, you can implement Row-level security on a Fabric Warehouse 😁 and it is well documented by MSFTm here'sthe main article from MSFT https://learn.microsoft.com/en-us/fabric/data-warehouse/row-level-security 

And with regards to how can I implement this in fabric?  In the article I shared there's very good information what it is, also explains the concept of the predicate-based row-level security, permission needed and provides an example 

My explnaition in simple terms

#1. You need to have within the rows you want to secure, what user or security group can see it 

#2. Create a function receving the user/group and return true(yes exists) / null (not exists)  

#3. Create a security policy that attached the validatino function to the table 

And that all about it, in a nutshell of course  😋

I would definely recommend you to read the documentation on this topis from MSFT, but I hope this give you a quick push in the right direction, best of lucks mate!  If you find this useful, a kudos will be nice and mark this as a solution ... cheers. 

[suparnababu8]

Hi @AdamMichael 

I written a blog about Row-Level Security in fabric. Please go though this blog Fine-grained ReadWrite access to data with OneLake... - Microsoft Fabric Community

Please let me know if it helps you!!

Thank you!!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!