Skip to content
cloudtools.fyi

SQL DB Contributor

Role definitionBuiltInRole

Lets you manage SQL databases, but not access to them. Also, you can't manage their security-related policies or their parent SQL servers.

ID9b7fa17d-e63e-47b0-bb0a-15c516ac86ec

Actions

11
Microsoft.Authorization/*/read
Microsoft.Insights/alertRules/*
Microsoft.Insights/metricDefinitions/read
Microsoft.Insights/metrics/read
Microsoft.ResourceHealth/availabilityStatuses/read
Microsoft.Resources/deployments/*
Microsoft.Resources/subscriptions/resourceGroups/read
Microsoft.Sql/locations/*/read
Microsoft.Sql/servers/databases/*
Microsoft.Sql/servers/read
Microsoft.Support/*

NotActions

29
Microsoft.Sql/managedInstances/advancedThreatProtectionSettings/*
Microsoft.Sql/managedInstances/databases/advancedThreatProtectionSettings/*
Microsoft.Sql/managedInstances/databases/currentSensitivityLabels/*
Microsoft.Sql/managedInstances/databases/recommendedSensitivityLabels/*
Microsoft.Sql/managedInstances/databases/schemas/tables/columns/sensitivityLabels/*
Microsoft.Sql/managedInstances/databases/securityAlertPolicies/*
Microsoft.Sql/managedInstances/databases/sensitivityLabels/*
Microsoft.Sql/managedInstances/databases/vulnerabilityAssessments/*
Microsoft.Sql/managedInstances/securityAlertPolicies/*
Microsoft.Sql/managedInstances/vulnerabilityAssessments/*
Microsoft.Sql/servers/databases/advancedThreatProtectionSettings/*
Microsoft.Sql/servers/databases/auditRecords/read
Microsoft.Sql/servers/databases/auditingSettings/*
Microsoft.Sql/servers/databases/currentSensitivityLabels/*
Microsoft.Sql/servers/databases/dataMaskingPolicies/*
Microsoft.Sql/servers/databases/extendedAuditingSettings/*
Microsoft.Sql/servers/databases/ledgerDigestUploads/disable/action
Microsoft.Sql/servers/databases/ledgerDigestUploads/write
Microsoft.Sql/servers/databases/recommendedSensitivityLabels/*
Microsoft.Sql/servers/databases/schemas/tables/columns/sensitivityLabels/*
Microsoft.Sql/servers/databases/securityAlertPolicies/*
Microsoft.Sql/servers/databases/securityMetrics/*
Microsoft.Sql/servers/databases/sensitivityLabels/*
Microsoft.Sql/servers/databases/sqlVulnerabilityAssessments/*
Microsoft.Sql/servers/databases/vulnerabilityAssessmentScans/*
Microsoft.Sql/servers/databases/vulnerabilityAssessmentSettings/*
Microsoft.Sql/servers/databases/vulnerabilityAssessments/*
Microsoft.Sql/servers/sqlVulnerabilityAssessments/*
Microsoft.Sql/servers/vulnerabilityAssessments/*

DataActions

0

None

NotDataActions

0

None

Assignable scopes

/