Events
31 Mar, 23 - 2 Apr, 23
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: ✅ SQL database in Microsoft Fabric
Fabric makes it easy to share items via the share button in the workspace. Fabric SQL database extends this experience by making it possible to share an item using granular SQL permissions. This allows things like sharing a single table in a database.
Open your workspace containing the database in the Fabric portal.
In the list of items, or in an open item, select the Share button.
The Grant people access dialog opens. Enter the names of the people or groups that need access.
The dialog offers a few simple options to grant broad access to the SQL database for scenarios where a database has been created for a single user or purpose. We'll skip checking any of those boxes here.
Choose whether to notify recipients with an email and add a message.
Select Grant.
The users now have access to connect to the database but are unable to do anything yet. The users can be added to SQL roles by selecting Manage SQL security from the Security menu in the database editor.
Select the db_datareader role and then Manage Access.
Add the users to the role and select Save.
Select the db_datawriter role and then Manage Access.
Add the users to the role and select Save.
The users now have access to read and write every table within the database. They won't have rights on any other Fabric items in the workspace unless they have also been granted. Instead of the broad roles, consider that users could be granted rights on individual tables to follow the principle of least privilege.
Note
Microsoft Purview protection policies can augment effective permission for database users. If your organization uses Microsoft Purview with Microsoft Fabric, see Protect sensitive data in SQL database with Microsoft Purview protection policies.
Events
31 Mar, 23 - 2 Apr, 23
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Secure data access in Microsoft Fabric - Training
Learn the key concepts and strategies for securing data access in Microsoft Fabric.
Certification
Microsoft Certified: Fabric Data Engineer Associate - Certifications
As a Fabric Data Engineer, you should have subject matter expertise with data loading patterns, data architectures, and orchestration processes.