Skip to content
cloudtools.fyi

SQL Security Manager

Role definitionBuiltInRole

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

ID056cd41c-7e88-42e1-933e-88ba6a50c9c3

Actions

65
Microsoft.Authorization/*/read
Microsoft.Insights/alertRules/*
Microsoft.Network/virtualNetworks/subnets/joinViaServiceEndpoint/action
Microsoft.ResourceHealth/availabilityStatuses/read
Microsoft.Resources/deployments/*
Microsoft.Resources/subscriptions/resourceGroups/read
Microsoft.Security/sqlVulnerabilityAssessments/*
Microsoft.Sql/locations/administratorAzureAsyncOperation/read
Microsoft.Sql/locations/ledgerDigestUploadsAzureAsyncOperation/read
Microsoft.Sql/locations/ledgerDigestUploadsOperationResults/read
Microsoft.Sql/locations/serverConfigurationOptionAzureAsyncOperation/read
Microsoft.Sql/managedInstances/administrators/read
Microsoft.Sql/managedInstances/advancedThreatProtectionSettings/read
Microsoft.Sql/managedInstances/advancedThreatProtectionSettings/write
Microsoft.Sql/managedInstances/azureADOnlyAuthentications/*
Microsoft.Sql/managedInstances/databases/advancedThreatProtectionSettings/read
Microsoft.Sql/managedInstances/databases/advancedThreatProtectionSettings/write
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/transparentDataEncryption/*
Microsoft.Sql/managedInstances/databases/vulnerabilityAssessments/*
Microsoft.Sql/managedInstances/read
Microsoft.Sql/managedInstances/securityAlertPolicies/*
Microsoft.Sql/managedInstances/serverConfigurationOptions/read
Microsoft.Sql/managedInstances/serverConfigurationOptions/write
Microsoft.Sql/managedInstances/vulnerabilityAssessments/*
Microsoft.Sql/servers/administrators/read
Microsoft.Sql/servers/advancedThreatProtectionSettings/read
Microsoft.Sql/servers/advancedThreatProtectionSettings/write
Microsoft.Sql/servers/auditingSettings/*
Microsoft.Sql/servers/azureADOnlyAuthentications/*
Microsoft.Sql/servers/databases/advancedThreatProtectionSettings/read
Microsoft.Sql/servers/databases/advancedThreatProtectionSettings/write
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/read
Microsoft.Sql/servers/databases/ledgerDigestUploads/*
Microsoft.Sql/servers/databases/read
Microsoft.Sql/servers/databases/recommendedSensitivityLabels/*
Microsoft.Sql/servers/databases/schemas/read
Microsoft.Sql/servers/databases/schemas/tables/columns/read
Microsoft.Sql/servers/databases/schemas/tables/columns/sensitivityLabels/*
Microsoft.Sql/servers/databases/schemas/tables/read
Microsoft.Sql/servers/databases/securityAlertPolicies/*
Microsoft.Sql/servers/databases/securityMetrics/*
Microsoft.Sql/servers/databases/sensitivityLabels/*
Microsoft.Sql/servers/databases/sqlvulnerabilityAssessments/*
Microsoft.Sql/servers/databases/transparentDataEncryption/*
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/*
Microsoft.Sql/servers/firewallRules/*
Microsoft.Sql/servers/read
Microsoft.Sql/servers/securityAlertPolicies/*
Microsoft.Sql/servers/sqlvulnerabilityAssessments/*
Microsoft.Sql/servers/vulnerabilityAssessments/*
Microsoft.Support/*

NotActions

0

None

DataActions

0

None

NotDataActions

0

None

Assignable scopes

/