topic Re: access readyonly datalake in Pipelines

access readyonly datalake

arkiboys2 — Thu, 06 Jun 2024 12:35:49 GMT

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

Re: access readyonly datalake

jwinchell40 — Thu, 06 Jun 2024 19:59:13 GMT

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

Re: access readyonly datalake

NandanHegde — Fri, 07 Jun 2024 03:45:34 GMT

You can create a custom role :

and select specific tables

Re: access readyonly datalake

arkiboys2 — Fri, 07 Jun 2024 12:58:04 GMT

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.

Re: access readyonly datalake

Anonymous — Mon, 10 Jun 2024 16:07:29 GMT

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

Hope this helps.