Resolving Permission Errors in Azure Synapse Level 3 Scans

Question

Why do I encounter permission errors when performing Level 3 scans in Azure Synapse, and how can I resolve them?

PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the Azure community.

Answer 1

Greetings!

When performing Level 3 scans in Azure Synapse, you may encounter permission errors stating that the user does not have permission to perform certain actions. This is typically due to the credentials being used for the scan lacking the necessary permissions, such as the SELECT permission for specific schemas or tables.

To resolve this issue, follow these steps:

1. Verify that the credentials used for the scan have the db_datareader role or SELECT permission for the entire database being scanned.
2. If the issue persists, grant the necessary permissions directly to the specific schema or table by executing the following query: GRANT SELECT ON schema.<tablename> TO <username>;
3. Follow the guidance provided in the official documentation to ensure all permissions are correctly configured: Grant permission to use credentials for external tables.

Regards

Geetha