azureblog.co.uk
← cd ~/roles
// roles/azure · databases

Azure Connected SQL Server OnboardingAzure built-in role

Microsoft.AzureArcData service role to access the resources of Microsoft.AzureArcData stored with RPSAAS.

Role IDe8113dce-c529-4d33-91fa-e9b972617508
CategoryDatabases
Actions2
Data actions0

What it can do

PermissionWhat it allows
Microsoft.AzureArcData/sqlServerInstances/read
Microsoft.AzureArcData/sqlServerInstances/write

Assign it

Scope it as tightly as you can: a resource or resource group rather than the whole subscription.

azure cli
az role assignment create \
  --assignee "jane.doe@contoso.com" \
  --role "Azure Connected SQL Server Onboarding" \
  --scope "/subscriptions/<subscription id>/resourceGroups/<resource group>"
powershell3 lines
New-AzRoleAssignment -SignInName "jane.doe@contoso.com" `
  -RoleDefinitionName "Azure Connected SQL Server Onboarding" `
  -Scope "/subscriptions/<subscription id>/resourceGroups/<resource group>"
bicep7 lines
resource assignment 'Microsoft.Authorization/roleAssignments@2022-04-01' = {
  name: guid(resourceGroup().id, principalId, 'e8113dce-c529-4d33-91fa-e9b972617508')
  properties: {
    roleDefinitionId: subscriptionResourceId('Microsoft.Authorization/roleDefinitions', 'e8113dce-c529-4d33-91fa-e9b972617508')
    principalId: principalId
  }
}

Who already has it?

kql · azure resource graph
authorizationresources
| where type == "microsoft.authorization/roleassignments"
| where tostring(properties.roleDefinitionId) endswith "e8113dce-c529-4d33-91fa-e9b972617508"
| project principalId = tostring(properties.principalId), principalType = tostring(properties.principalType), scope = tostring(properties.scope)

Other databases roles

Find the smallest role for a task →

Sources