Microsoft.Sql servers/databases/dataMaskingPolicies 2014-04-01

Template format

To create a Microsoft.Sql/servers/databases/dataMaskingPolicies resource, add the following JSON to the resources section of your template.

  "name": "Default",
  "type": "Microsoft.Sql/servers/databases/dataMaskingPolicies",
  "apiVersion": "2014-04-01",
  "properties": {
    "dataMaskingState": "string",
    "exemptPrincipals": "string"
  "resources": []

Property values

The following tables describe the values you need to set in the schema.

Microsoft.Sql/servers/databases/dataMaskingPolicies object

Name Type Required Value
name enum Yes The name of the database for which the data masking rule applies. - Default
type enum Yes dataMaskingPolicies

See Set name and type for child resources.
apiVersion enum Yes 2014-04-01
properties object Yes The properties of the data masking policy. - DataMaskingPolicyProperties object
resources array No rules

DataMaskingPolicyProperties object

Name Type Required Value
dataMaskingState enum Yes The state of the data masking policy. - Disabled or Enabled
exemptPrincipals string No The list of the exempt principals. Specifies the semicolon-separated list of database users for which the data masking policy does not apply. The specified users receive data results without masking for all of the database queries.