Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.