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!
Community SupportHi koltonist,
I wanted to check if you had the opportunity to review the information provided by suparnababu8. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.