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 Bollineni

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