Forum Discussion

MaxBronder's avatar
MaxBronder
Frequent Visitor
2 years ago

Implementing row level security for groups in a lakehouse

Hi everyone,

 

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? 

Thx and KR 

Data Engineering
Lakehouse

8 Replies

    • MaxBronder's avatar
      MaxBronder
      Frequent Visitor
      2 years ago

      Hi, 
      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's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi MaxBronder ,

        Currently Fabric only supports the functionalities present in the doc. 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.

         

        Appreciate if you could share the feedback on our Microsoft Fabric Ideas. Which would be open for the user community to upvote & 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.

         

        I hope this information helps. If you have any further queries please do let us know.

        Thanks