Implementing row level security for groups in a lakehouse

Question

Hi everyone,&nbsp;I'm currently looking for a solution to implement row level security based on group membership for lakehouse tables.From what Microsoft describes in the documentation only the USER_NAME(), SUSER_NAME() and SUSER_SNAME() are currently supported, which I dont find helpfull.Is there any workaround, I havent found yet?&nbsp;Thx and KR&nbsp;

maxbronder · Answer

Hi&nbsp;Anonymous&nbsp;&nbsp;it´s an answer but definitely not a solution.Basically you´re saying that currently there is no way to implement row level security for AD groups, correct?It´s very disapointing, I can hardly imagine any use case where usernames would make any sense.Can you at least tell if it is on the roadmap to add ad group support?&nbsp;thx and KR

anonymous · Answer

Hi&nbsp;MaxBronder&nbsp;,Thanks for using Fabric Community.Did you checked this doc?Row-level security in Fabric data warehousing - Microsoft Fabric | Microsoft LearnHope this is helpful Please let me know if you have further queries.

maxbronder · Answer

Hi,&nbsp;yes I checked the doc, but as I said in my message, there only the USER_NAME() function is used and I haven't found smth similar for groups.

anonymous · Answer

Hi&nbsp;MaxBronder&nbsp;,
Currently Fabric only supports the functionalities present in the doc.&nbsp;However, your suggestion is definitely valuable! We use customer feedback like yours to prioritize future features. The more users who request the ability to customize backgrounds, the higher it moves on our list.
&nbsp;
Appreciate if you could share the feedback on our&nbsp;Microsoft Fabric Ideas. Which would be open for the user community to upvote &amp; comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.
&nbsp;
I hope this information helps. If you have any further queries please do let us know.
Thanks

anonymous · Answer

Hi&nbsp;MaxBronder&nbsp;,We haven’t heard from you on the last response and was just checking back to see if your query was answered.Otherwise, will respond back with the more details and we will try to help .Thanks

Forum Discussion

Implementing row level security for groups in a lakehouse

Related content

Lakehouse table security

How to implement RLS and CLS using Onelake security in Lakehouse?

Implementing Region-Level Security

One Lake Security implementation doubts

RLS,CLS Security Design and Implementation