Turbot Guardrails Hub 
Hub
  • Mods
  • Policy Packs
  • Docs
  • Home
ModsPolicy PacksDocsHome
Mods
Azure
Loading controls...

Control: Azure > SQL > Server > Advanced Data Security

Define the advanced data security settings required for Azure > SQL > Server.

Advanced data security for SQL Server includes functionality for surfacing and mitigating potential database vulnerabilities and detecting anomalous activities that could indicate a threat to your server. The Advanced data security package provides administrators with a single go-to location for discovering and classifying data, assessing and addressing potential database vulnerabilities, and visibility into anomalous and potentially malicious activity that is taking place.

Advanced data security can be defined for a specific database or as a default server policy. A server policy applies to all existing and newly created databases on the server. Azure recommends to enable only server-level data security and leave the database-level data security disabled for all databases.

The Advanced data security control compares the vulnerability assessment and threat protection settings against the advanced data security policies for the resource (Azue > SQL > Server > Advanced Data Security > *), raises an alarm, and takes the defined enforcement action.

Resource Types

This control targets the following resource types:

  • Azure > SQL > Server

Policies

The following policies can be used to configure this control:

  • Azure > SQL > Server > Advanced Data Security

This control type relies on these other policies when running actions:

  • Azure > SQL > Server > Advanced Data Security > Vulnerability Assessment > Storage Account
  • Azure > SQL > Server > Advanced Data Security > Vulnerability Assessment > Periodic Scans
  • Azure > SQL > Server > Advanced Data Security > Vulnerability Assessment > Periodic Scans > Email Addresses
  • Azure > SQL > Server > Advanced Data Security > Vulnerability Assessment > Periodic Scans > Notify Admins
  • Azure > SQL > Server > Advanced Data Security > Threat Protection > Types
  • Azure > SQL > Server > Advanced Data Security > Threat Protection > Email Addresses
  • Azure > SQL > Server > Advanced Data Security > Threat Protection > Notify Admins

Permissions

Cloud permissions used by this control and its actions:

  • microsoft.sql/servers/vulnerabilityassessments/write
  • microsoft.sql/servers/securityalertpolicies/write
  • microsoft.storage/storageaccounts/listkeys/action
  • microsoft.storage/storageaccounts/read

Category

  • Security

In Your Workspace

  • Controls by Resource report
  • Controls by Control Type report

Developers

    Control Type URI
    • tmod:@turbot/azure-sql#/control/types/serverDataSecurity
  • Category URI
    • tmod:@turbot/turbot#/control/categories/security
  • GraphQL
    • query controlType(id: "tmod:@turbot/azure-sql#/control/types/serverDataSecurity") { … }
    • query controls(filter: "controlTypeId:'tmod:@turbot/azure-sql#/control/types/serverDataSecurity'") { … }
  • CLI
    • Get Controls
    • turbot graphql controls --filter "controlTypeId:tmod:@turbot/azure-sql#/control/types/serverDataSecurity"
Guardrails
Guardrails Hub
  • Hub
  • Docs
  • Blog
  • Changelog
Products
  • GuardrailsGuardrails
  • PipesPipes
  • SteampipeSteampipe
  • PowerpipePowerpipe
  • FlowpipeFlowpipe
  • TailpipeTailpipe
Turbot
  • Home
  • About us
  • We're hiring!
  • Contact us
Community

Our community of practitioners love to discuss cloud governance & security.

Slack logoJoin us on Slack →

System StatusLegalSecurity
Terms of UseSecurityPrivacy
50
Mods
205
Resource Types
3,574
Policies
1,936
Controls
103
Quick Actions
114
IAM