- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
access readyonly datalake
hi,
not sure where exactly to post this question and so I hope it is ok to post it here
using the fabric data factory, I have populated lakehouse with a table
Now in the lakehouse I would like to give readonly access to a user to select * from table
How can I give readonly access to the user and furthermore, how is it possible to give readonly access to the table?
thank you
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can create a custom role :
and select specific tables
----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can create a custom role :
and select specific tables
----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi,
I see these tables as disabled and when I click on th eexclamation mark next to each of these tables, it says I have to set permissions at destination.
Currently the power bi is pointing to the fabric semantic model.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @arkiboys2
As mentioned by @NandanHegde you can create a new role assignment as follows:
Hope this helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@arkiboys2 - Take a look at this article, it covers securing the SQL Side of OneLake with your standard SQL Permissions:
- https://learn.microsoft.com/en-us/fabric/data-warehouse/sql-granular-permissions
This article is also a good one that goes through setting permissions in OneLake as well:
- https://learn.microsoft.com/en-us/fabric/onelake/security/data-access-control-model

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
01-25-2025 05:53 AM | |||
11-28-2024 01:55 AM | |||
02-21-2024 08:24 PM | |||
01-14-2025 02:57 PM | |||
12-12-2024 06:27 AM |
User | Count |
---|---|
8 | |
7 | |
6 | |
4 | |
3 |