access readyonly datalake

[arkiboys2]

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

[NandanHegde · Accepted solution]

You can create a custom role :

and select specific tables

[arkiboys2]

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.

[v-nikhilan-msft]

Hi @arkiboys2 
As mentioned by @NandanHegde you can create a new role assignment as follows:

Hope this helps.

[jwinchell40]

@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