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 fdnavarropecci, thanks for your detailed thought process. I am like you where after I ran "GRANT SELECT ON [lakehouse_demo].[dbo].[Customer10] TO [username];", this [username] could see every single tables and views even though we only granted this [username] one view. Have you found a solution to this yet?
Hi PatChan , we tested this again and is now working as expected. We suspect it was related to some role assignments that were removed shortly before granting access to the item.