Forum Discussion
Power ParticipantTrouble Implementing Column-Level Security in Microsoft Fabric for Specific User
It turns out it was the format of the T-SQL statement I should have written it like this:
GRANT SELECT (CustomerID, CustomerName) ON Sales.Dim_Customer
TO [[email protected]];The other format (althought it executes correctly gives a warning):
This was incredibly frustraing because this was the format Microsoft suggested in their guide:
https://learn.microsoft.com/en-us/fabric/data-warehouse/tutorial-column-level-security
Most Valuable ProfessionalHi HamidBee when you shared the Warehouse, what level of sharing did you give the user?
"Default permissions (no additional options selected)" should allow you to share the warehouse with Connect only permissions, then use GRANT to assign the relevant permissions
https://blog.fabric.microsoft.com/en-us/blog/data-warehouse-sharing/
HamidBeeIt turns out it was the format of the T-SQL statement I should have written it like this:
GRANT SELECT (CustomerID, CustomerName) ON Sales.Dim_Customer
TO [[email protected]];The other format (althought it executes correctly gives a warning):
This was incredibly frustraing because this was the format Microsoft suggested in their guide:
https://learn.microsoft.com/en-us/fabric/data-warehouse/tutorial-column-level-security