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

Storage Table DelegatorAzure built-in role

Allows for generation of a user delegation key, which can then be used to create a shared access signature for an Azure Storage table that is signed with Entra ID credentials.

Role ID965033a5-c8eb-4f35-b82f-fef460a3606d
CategoryStorage
Actions1
Data actions0

What it can do

PermissionWhat it allows
Microsoft.Storage/storageAccounts/tableServices/generateUserDelegationKey/actionReturns a user delegation key for the table service

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 "Storage Table Delegator" \
  --scope "/subscriptions/<subscription id>/resourceGroups/<resource group>"
powershell3 lines
New-AzRoleAssignment -SignInName "jane.doe@contoso.com" `
  -RoleDefinitionName "Storage Table Delegator" `
  -Scope "/subscriptions/<subscription id>/resourceGroups/<resource group>"
bicep7 lines
resource assignment 'Microsoft.Authorization/roleAssignments@2022-04-01' = {
  name: guid(resourceGroup().id, principalId, '965033a5-c8eb-4f35-b82f-fef460a3606d')
  properties: {
    roleDefinitionId: subscriptionResourceId('Microsoft.Authorization/roleDefinitions', '965033a5-c8eb-4f35-b82f-fef460a3606d')
    principalId: principalId
  }
}

Who already has it?

kql · azure resource graph
authorizationresources
| where type == "microsoft.authorization/roleassignments"
| where tostring(properties.roleDefinitionId) endswith "965033a5-c8eb-4f35-b82f-fef460a3606d"
| project principalId = tostring(properties.principalId), principalType = tostring(properties.principalType), scope = tostring(properties.scope)

Other storage roles

Find the smallest role for a task →

Sources