Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join now60 Days of Data Days! Live and on-demand sessions, challenges, study groups and more! And it's all FREE!. Join now. Learn more
Hi,
I am testing onelake security on lakehouse and can't get it working.
As a test I have set it up for a single user. User has no access granted on the workspace instead the lakehouse was shared with Read permission.
I have removed the DefaultRole and added a new ALLTables ReadWrite permissions for admin and contributor members. User being used for testing is not part of the ALLTables role.
Things I have tried but still no luck.
Gave user Read + ReadAll permission on the lakehouse.
I did give around an hour or so for the security setup to sync and then asked user to try the access.
Any help how to get this setup working successfully.
Non Schema Lakehouse Setup
Error
An error occurred.
Message : User is not authorized to access the files in storage path '/074314b1-3165-46b6-b217-ba55daf9bf71/e693dc03-27ec-4f6a-8f2e-1507546ebd3b/Tables/customer/_delta_log' for the table.
Error Code : UnauthorizedToAccessTableFiles
Error source : 1
Schema Enabled Lakhouse Setup
Error
An error occurred.
Message : User is not authorized to access the files in storage path '/074314b1-3165-46b6-b217-ba55daf9bf71/7b19579d-f053-47fd-95d9-3fd68e0407ff/Tables/dbo/salesorderheader/_delta_log' for the table.
Error Code : UnauthorizedToAccessTableFiles
Error source : 1
Thanks,
Gayatri
| User | Count |
|---|---|
| 33 | |
| 10 | |
| 8 | |
| 6 | |
| 5 |
| User | Count |
|---|---|
| 52 | |
| 27 | |
| 18 | |
| 18 | |
| 15 |