Hi @MrFlinstone
Thank you for reaching out to the community forum with your query.
Regarding your unauthorized status, it seems you don't have sufficient permissions to view the pools in Synapse Studio. You will need either Synapse Administrator or Synapse SQL Administrator permissions. If you don't have these permissions, please follow the instructions in the image below to have your login added to the required role.
Regarding the issue with assigning role, it's possible that you don't have the necessary permissions to assign roles in the Synapse workspace. To assign roles, you need to have the Owner or User Access Administrator role in the Azure subscription. If you don't have these roles, you can ask your Azure administrator to grant you the necessary permissions.
If you have the necessary permissions but still can't assign roles, try using Azure PowerShell or Azure CLI to do it. Here's an example command to assign the Storage Blob Data Contributor role to a user:
New-AzRoleAssignment -ObjectId <User Object ID> -RoleDefinitionName "Storage Blob Data Contributor" -Scope <Workspace Resource ID>
Replace <User Object ID>
with the user's object ID and <Workspace Resource ID>
with your Synapse workspace's resource ID.
Another possible reason is this could be an intermittent issue while opening synapse workspace. You can also try logging in manually at https://web.azuresynapse.net and signing into your workspace.
Hope this helps. Do let us know if you any further queries.
If this answers your query, do click Accept Answer
and Yes
for was this answer helpful. And, if you have any further query do let us know.