Forum Discussion
What does ReadData permisison mean?
According to MS documentation, if we only want to share one table in the data warehouse with another user, we should first give the user ReadDate permission to the warehouse (only read, not readAll SQL endpoint or readAll Spark endpoint), then give the user permission to the table via SQL grant select command.
So below are my questions:
1. if the same user connects to the warehouse via Power BI Desktop using sql connection, can he import the whole warehouse?
2. if the same user connect to the data warehouse via SSMS using sql connection, can he view the whole warehouse?
This question is really critical and I have read lots confusing documentation from Microsoft, please kindly do some test before answering! Thanks a lot! As I only have a free Azure Account, I can't run the test myself.
1. no, ReadData just lets the user connect to the database like SQL Server
2, No
You can test this with a new user that you have password for and setup with your infrastructure ro security team
2 Replies
1. no, ReadData just lets the user connect to the database like SQL Server
2, No
You can test this with a new user that you have password for and setup with your infrastructure ro security team
You can explicitly grant access on individual tables to the user via TSQL query ::https://community.fabric.microsoft.com/t5/Data-Warehouse/How-to-grant-access-for-specific-tables-to-e-mail-address-in/m-p/4030381
via granular permission rather ReadData permission
