azureblog.co.uk
← cd ~/graph-permissions
// graph-permissions · Workbooks

Workbooks.ReadWrite.AllMicrosoft Graph permission · High risk

Allows the app to read and write all workbooks without a signed-in user.

Application permission

High risk

Read and write all workbooks. Allows the app to read and write all workbooks without a signed-in user.

ID164a9e2c-8434-444a-a250-b8c70dded2af
ConsentAlways needs admin consent
RiskCan change data across the whole tenant.

Delegated permission

High risk

Read and write all workbooks. Allows the app to read and write all workbooks on behalf of the signed-in user.

ID5cf5c2d4-f542-4e67-b524-51ab19ef7584
ConsentNeeds admin consent
RiskCan change data across the whole tenant.

Grant it to an app

In the portal: App registrations › your app › API permissions › Add a permission › Microsoft Graph › Application permissions, then grant admin consent. Or with Graph PowerShell:

powershell5 lines
Connect-MgGraph -Scopes "Application.Read.All", "AppRoleAssignment.ReadWrite.All"
$graph = Get-MgServicePrincipal -Filter "appId eq '00000003-0000-0000-c000-000000000000'"
$app   = Get-MgServicePrincipal -Filter "appId eq '<your app's client id>'"
New-MgServicePrincipalAppRoleAssignment -ServicePrincipalId $app.Id `
    -PrincipalId $app.Id -ResourceId $graph.Id -AppRoleId "164a9e2c-8434-444a-a250-b8c70dded2af"

Ask for it when signing in

Delegated permissions act as the signed-in user, so the app can never do more than that user can.

powershell1 line
Connect-MgGraph -Scopes "Workbooks.ReadWrite.All"

Which apps already have it?

powershell6 lines
# Apps that hold Workbooks.ReadWrite.All as an application permission
Connect-MgGraph -Scopes "Application.Read.All"
$graph = Get-MgServicePrincipal -Filter "appId eq '00000003-0000-0000-c000-000000000000'"
Get-MgServicePrincipalAppRoleAssignedTo -ServicePrincipalId $graph.Id -All |
    Where-Object AppRoleId -eq "164a9e2c-8434-444a-a250-b8c70dded2af" |
    Select-Object PrincipalDisplayName, PrincipalId, CreatedDateTime
powershell6 lines
# Apps with delegated consent for Workbooks.ReadWrite.All
Connect-MgGraph -Scopes "Application.Read.All", "Directory.Read.All"
$graph = Get-MgServicePrincipal -Filter "appId eq '00000003-0000-0000-c000-000000000000'"
Get-MgOauth2PermissionGrant -All |
    Where-Object { $_.ResourceId -eq $graph.Id -and ($_.Scope -split " ") -contains "Workbooks.ReadWrite.All" } |
    Select-Object ClientId, ConsentType, PrincipalId

Other Workbooks permissions

Check every app in your tenant → Permission explainer

Sources