Error 1: Failed to load one or more resources due to no access, error code 403.
I checked with the answers here but they don’t work for me. As the screenshots below suggest, I am the service administrator, owner and contributor of the Synapse workspace. I also allow public access to the Synapse workspace.
Error 2: If I check the access control on Synapse studio portal, it says I am not the synapse administrator but I am actually the service administrator of the entire subscription.
2
Answers
The Azure IAM/RBAC roles are for working with the Azure resource, but the Synapse workspace also has its own access control. You will need to grant permissions/RBAC inside the workspace itself. [documentation]
I recommend using Groups to manage permissions, but you can start by adding yourself as a Synapse Administrator.
This article – Disabling Public Network Access in Synapse helps to resolve the issue.
For more details, refer to Grant access to SQL pools.