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!