Forum Discussion
T-SQL shortcut security
Hello koltonist
Yes, you are 100% correct. If you create shortcuts to tables in a second Lakehouse, the column level security from the first Lakehouse won't transfer automatically. You'll have to set up the security settings again for the shortcut tables in the second Lakehouse. Therfore, by setting up the security settings again, you can keep the data safe and make sure users can only see the columns they are allowed to access.
If you need additional info, Pls read the below official documentations. It might helps you
Implement column-level security in Fabric data warehousing - Microsoft Fabric | Microsoft Learn
Referencing data to a Lakehouse using shortcuts - Microsoft Fabric | Microsoft Learn
Column-level security in Fabric data warehousing - Microsoft Fabric | Microsoft Learn
Thank you!!!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Super UserHello koltonist
Yes, you are 100% correct. If you create shortcuts to tables in a second Lakehouse, the column level security from the first Lakehouse won't transfer automatically. You'll have to set up the security settings again for the shortcut tables in the second Lakehouse. Therfore, by setting up the security settings again, you can keep the data safe and make sure users can only see the columns they are allowed to access.
If you need additional info, Pls read the below official documentations. It might helps you
Implement column-level security in Fabric data warehousing - Microsoft Fabric | Microsoft Learn
Referencing data to a Lakehouse using shortcuts - Microsoft Fabric | Microsoft Learn
Column-level security in Fabric data warehousing - Microsoft Fabric | Microsoft Learn
Thank you!!!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Are there plans from Microsoft to make it possible to inherit the T-SQL security?
- suparnababu8
Hi koltonist
I'm not sure on the future plans. Inheriting T-SQL security would be valuable feature for lot of users are expecting from microsoft. So, as I mentioned earlier, this idea got enough votes, the will try to bring this in future.
Thank you!!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User! 
v-saisrao-msftCommunity Support
Hi koltonist,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.