Seeking Guidance on Granting 'Read' Access in Azure Synapse Serverless SQL Pool

Nicole Inman 1 Reputation point

Hello Azure Community,

I'm currently working on an Azure Synapse Analytics workspace project utilizing a serverless SQL pool. We rely on a SAS token to access our data stored in Azure Data Lake. This data is then presented within a Power Platform canvas app.

Our main objective is to allow an AAD group (or group) 'Read' access to the data within the serverless SQL pool. Despite my capacity as the service owner and numerous attempts at configuring permissions, I find myself unable to accomplish the desired access control. It's critical for us to strictly confine the specific user or group's access to 'Read' only operations to comply with our organization's stringent data security policies.

Despite my efforts, I'm unable to achieve the required configuration. Your insights and recommendations on this matter would be highly appreciated.

Looking forward to your valuable responses.

Best Regards,


Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
991 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
3,096 questions
Azure Role-based access control
Azure Role-based access control
An Azure service that provides fine-grained access management for Azure resources, enabling you to grant users only the rights they need to perform their jobs.
448 questions
{count} votes

1 answer

Sort by: Most helpful
  1. risolis 8,151 Reputation points

    Hello @Nicole Inman

    Thank you for posting this case scenario on this community.

    I fully understand your concern so I shall try to address you on this one. For instance, you can either delegate permissions from the AAD or PIM (Privilege Identity Management as well.

    Please direct yourself to the following links down below:

    I hope that might be useful for you and get it done.

    Looking forward to hearing from you


    Please "Accept the answer" if the information helped you. This will help us and others in the community.