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

Storage Table Data ContributorAzure built-in role

Allows for read, write and delete access to Azure Storage tables and entities

Role ID0a9a7e1f-b9d0-4cc4-a60d-0319b160aaa3
CategoryStorage
Actions3
Data actions5

Before you assign it

  • It reaches the data, not just the resource. It has 5 data actions, such as reading blobs, secrets or messages.

What it can do

PermissionWhat it allows
Microsoft.Storage/storageAccounts/tableServices/tables/read
Microsoft.Storage/storageAccounts/tableServices/tables/write
Microsoft.Storage/storageAccounts/tableServices/tables/delete

Data actions

PermissionWhat it allows
Microsoft.Storage/storageAccounts/tableServices/tables/entities/readQuery table entities
Microsoft.Storage/storageAccounts/tableServices/tables/entities/writeInsert, merge, or replace table entities
Microsoft.Storage/storageAccounts/tableServices/tables/entities/deleteDelete table entities
Microsoft.Storage/storageAccounts/tableServices/tables/entities/add/actionInsert table entities
Microsoft.Storage/storageAccounts/tableServices/tables/entities/update/actionMerge or update table entities

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 Data Contributor" \
  --scope "/subscriptions/<subscription id>/resourceGroups/<resource group>"
powershell3 lines
New-AzRoleAssignment -SignInName "jane.doe@contoso.com" `
  -RoleDefinitionName "Storage Table Data Contributor" `
  -Scope "/subscriptions/<subscription id>/resourceGroups/<resource group>"
bicep7 lines
resource assignment 'Microsoft.Authorization/roleAssignments@2022-04-01' = {
  name: guid(resourceGroup().id, principalId, '0a9a7e1f-b9d0-4cc4-a60d-0319b160aaa3')
  properties: {
    roleDefinitionId: subscriptionResourceId('Microsoft.Authorization/roleDefinitions', '0a9a7e1f-b9d0-4cc4-a60d-0319b160aaa3')
    principalId: principalId
  }
}

Who already has it?

kql · azure resource graph
authorizationresources
| where type == "microsoft.authorization/roleassignments"
| where tostring(properties.roleDefinitionId) endswith "0a9a7e1f-b9d0-4cc4-a60d-0319b160aaa3"
| project principalId = tostring(properties.principalId), principalType = tostring(properties.principalType), scope = tostring(properties.scope)

Other storage roles

Find the smallest role for a task →

Sources