Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

60 Days of Data Days! Live and on-demand sessions, challenges, study groups and more! And it's all FREE!. Join now. Learn more

Reply
g3kuser
Helper I
Helper I

Issue with Onelake security RLS

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

g3kuser_0-1784168420465.png

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

g3kuser_1-1784168919480.png
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

0 REPLIES 0

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.