Forum Discussion
How to Grant Access to an Individual Table/View in SQL Analytics Endpoint for a Lakehouse?
Hi mramesh Good Day!
For example, to give a specific user access to a view, you can use T-SQL
GRANT SELECT ON [lakehouse_demo].[dbo].[Customer10] TO [username];
For doc pls check below
What is the SQL analytics endpoint for a lakehouse? - Microsoft Fabric | Microsoft Learn
Lakehouse sharing and permission management - Microsoft Fabric | Microsoft Learn
Regards,
Venu BollineniHi mramesh further to what VenuBollineni said, you also need to "share" the lakehouse with the user (or group). Make sure you don't check any of the options, doing this will only give the user "connect" permissions to the Lakehouse SQL Endpoint. Then the object level permissions as described by VenuBollineni will kick in
Hi mramesh further to what VenuBollineni said, you also need to "share" the lakehouse with the user (or group). Make sure you don't check any of the options, doing this will only give the user "connect" permissions to the Lakehouse SQL Endpoint. Then the object level permissions as described by VenuBollineni will kick in
Hi,
I performed the steps mentioned below but I am getting the below error
User is not authorized to perform current operation for workspace '39d311d6-640e-4655-8757-ab01acca075a', artifact '76085361-7964-470c-a992-3e6d82a64ac8'.What needs to be done here, if I don't the user to be able to view all the items unders the workspace.
This looks like you're missing permissions to share the item, you need either member or admin role at the workspace level to be able to do so.
Thanks for your response fdnavarropecci!
But I am the platform and the workspace admin, just by following the above steps, I am still not able to provide the permission to view the table data. Is it possible to list all the steps so that i can try them in the same order.
