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:
- Implement row-level security (RLS) by using the CREATE SECURITY POLICY Transact-SQL statement, and predicates created as inline table-valued functions.
- Implement column-level security (CLS) with the GRANT T-SQL statement. For simplicity of management, assigning permissions to roles is preferred to using individuals.
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 SQL analytics endpoint in Microsoft Fabric.