Forum Discussion
One Lake Security - Row Security not available
Hello, I try to configure row level security with OneLake security feature. After creating a role, I can't see the option "Row Security" when I click the 3 dots on a specific table within a role. I read the following link, but I also can't find where to switch the SQL Analytics Endpoint on the lakehouse to "User's identity" mode through the Security tab. I have F2 license and Trial.
https://learn.microsoft.com/en-us/fabric/onelake/security/row-level-security
You don't see the “Row security” option and can't switch the SQL Analytics Endpoint to “User’s identity” mode because your workspace is running on F2 (free) capacity, which does not support those features. You need to upgrade to at least F64 capacity or P1 Premium, which are required to enable both the Row-Level Security UI and the user's identity mode for the SQL Analytics endpoint.
8 Replies
I have this exact issue. My Fabric capacity is F256 and I am the workspace admin. It is said in the microsoft documentation in the below link that User Access Mode has to be: User's Identity, but I can't see the security tab anywhere... does anyone has any idea?
https://learn.microsoft.com/en-us/fabric/onelake/security/row-level-security
The same issue. I can't see the security tab anywhere, even through my capacity is F64.
Hi MorenaBI,
It appears the issue is related to capacity limitations. With an F2 (free) capacity, features such as 'Row Security' and 'User's identity' mode are not available. Upgrading your workspace to F64 capacity or higher, or to a P1 Premium capacity, should enable these features.
Thank you.
Thank you for your feedback. Can I create RLS on a lakehouse object in a different way? Does SQL security work the same as on warehouse objects?
Hi MorenaBI,
Yes, SQL-based row-level security is supported on Fabric Warehouses. You can use standard T-SQL syntax, including CREATE SECURITY POLICY and predicate functions, just as you would in Azure SQL or Synapse.
Row-Level Security in Fabric Data Warehousing - Microsoft Fabric | Microsoft Learn
Thank you.
Hi MorenaBI,
Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.
Thank you.
Hi MorenaBI,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.
You don't see the “Row security” option and can't switch the SQL Analytics Endpoint to “User’s identity” mode because your workspace is running on F2 (free) capacity, which does not support those features. You need to upgrade to at least F64 capacity or P1 Premium, which are required to enable both the Row-Level Security UI and the user's identity mode for the SQL Analytics endpoint.
