Forum Discussion
Azure AD Security Group In Lakehouse SQL analytics endpoint
Hi verianalizi ,
Thanks for using Fabric Community.
RLS security in SQL Endpoint - Fabric with Security Groups can be implemented.
For detail process please check this link for reference.
Hope this is helpful. Please let me know incase of further queries.
Hello thank you for your response but I can't access the link. "about:blank#blocked"
Hi verianalizi ,
Please refer this link - Row-level security in Fabric data warehousing - Microsoft Fabric | Microsoft LearnHi Anonymous,
The approach shown in the link, is using USER_NAME() for single user only.
-- Creating a function for the SalesRep evaluation CREATE FUNCTION Security.tvf_securitypredicate(@SalesRep AS nvarchar(50)) RETURNS TABLE WITH SCHEMABINDING AS RETURN SELECT 1 AS tvf_securitypredicate_result WHERE @SalesRep = USER_NAME() OR USER_NAME() = '[email protected]'; GO
How can we do it for Entra ID security groups?
I have tried to do that, but I wasn't succesful. Can you provide some guidance. Please see my post: SQL Analytics Endpoint - RLS for Security Groups - Microsoft Fabric Community
