Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
How to grant access for specific tables to e-mail address in Fabric Data Warehouse and Lakehouse
Solved! Go to Solution.
You can use Grant command to give access on specific tables in fabric warehouse:
for lakehouse, you can create a role:
syntax to give permission on tables and schemas. Below works on both lakehouse and warehouse.
grant select on dbo.table_name to [myname@mail.com]
GRANT select on schema :: schema_name to [myname@mail.com]
syntax to give permission on tables and schemas. Below works on both lakehouse and warehouse.
grant select on dbo.table_name to [myname@mail.com]
GRANT select on schema :: schema_name to [myname@mail.com]
Hi @dinesh01 ,
Your solution is great, @NandanHegde . It worked like a charm!
For Fabric Data Warehouse:
Assign workspace roles:
Grant granular permissions:
For more information, please see:
SQL granular permissions - Microsoft Fabric | Microsoft Learn
For Lakehouse:
Share a Lakehouse:
Manage permissions:
Folder-level access control:
For more information, please see:
Lakehouse sharing and permission management - Microsoft Fabric | Microsoft Learn
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
You can use Grant command to give access on specific tables in fabric warehouse:
for lakehouse, you can create a role:
It might sound like a stupid question. I have given a user access to a table in Fabric warehouse via the grant command, but as this user doesn't have acess to the Fabric warehouse, how can he/she access the table? I tried the absf path and Power BI desktop - onelake hub, neither works.
User | Count |
---|---|
7 | |
4 | |
2 | |
2 | |
1 |