Forum Discussion
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
You can create a custom role :
and select specific tables
4 Replies
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
You can create a custom role :
and select specific tables
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.
Hi arkiboys2
As mentioned by NandanHegde you can create a new role assignment as follows:
Hope this helps.
