Skip to content
cloudtools.fyi

SQL Server Contributor

Role definitionBuiltInRole

Lets you manage SQL servers and databases, but not access to them, and not their security -related policies.

ID6d8ee4ec-f05a-4a1d-8b00-a9b17e38b437

Actions

10
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/*
Microsoft.Support/*

NotActions

36
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/advancedThreatProtectionSettings/*
Microsoft.Sql/servers/auditingSettings/*
Microsoft.Sql/servers/azureADOnlyAuthentications/delete
Microsoft.Sql/servers/azureADOnlyAuthentications/write
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/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/devOpsAuditingSettings/*
Microsoft.Sql/servers/extendedAuditingSettings/*
Microsoft.Sql/servers/externalPolicyBasedAuthorizations/delete
Microsoft.Sql/servers/externalPolicyBasedAuthorizations/write
Microsoft.Sql/servers/securityAlertPolicies/*
Microsoft.Sql/servers/sqlVulnerabilityAssessments/*
Microsoft.Sql/servers/vulnerabilityAssessments/*

DataActions

0

None

NotDataActions

0

None

Assignable scopes

/