How to: Secure mirrored data in Microsoft Fabric SQL database (preview)
This guide helps you establish data security for the mirrored data of your Fabric SQL database.
Important topics to review:
- Authorization in SQL database in Microsoft Fabric
- Authentication in SQL database in Microsoft Fabric
- Share your SQL database and manage permissions
Data protection features
You can secure column filters and predicate-based row filters on tables to roles and users in Microsoft Fabric:
You can also mask sensitive data from non-admins using dynamic data masking:
Important
Any granular security established on objects in the Fabric SQL database must be re-configured in the analytics endpoint in Microsoft Fabric.