Data Masking Policies - Create Or Update

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-6852/providers/Microsoft.Sql/servers/sqlcrudtest-2080/databases/sqlcrudtest-331/dataMaskingPolicies/Default?api-version=2023-08-01 { "properties": { "dataMaskingState": "Enabled", "exemptPrincipals": "testuser;" } } 

using Azure; using Azure.ResourceManager; using System; using System.Threading.Tasks; using Azure.Core; using Azure.Identity; using Azure.ResourceManager.Sql.Models; using Azure.ResourceManager.Sql; // Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/stable/2023-08-01/examples/DataMaskingPolicyCreateOrUpdateMax.json // this example is just showing the usage of "DataMaskingPolicies_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately. // get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line TokenCredential cred = new DefaultAzureCredential(); // authenticate your client ArmClient client = new ArmClient(cred); // this example assumes you already have this DataMaskingPolicyResource created on azure // for more information of creating DataMaskingPolicyResource, please refer to the document of DataMaskingPolicyResource string subscriptionId = "00000000-1111-2222-3333-444444444444"; string resourceGroupName = "sqlcrudtest-6852"; string serverName = "sqlcrudtest-2080"; string databaseName = "sqlcrudtest-331"; DataMaskingPolicyName dataMaskingPolicyName = DataMaskingPolicyName.Default; ResourceIdentifier dataMaskingPolicyResourceId = DataMaskingPolicyResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName, databaseName, dataMaskingPolicyName); DataMaskingPolicyResource dataMaskingPolicy = client.GetDataMaskingPolicyResource(dataMaskingPolicyResourceId); // invoke the operation DataMaskingPolicyData data = new DataMaskingPolicyData { DataMaskingState = DataMaskingState.Enabled, ExemptPrincipals = "testuser;", }; ArmOperation<DataMaskingPolicyResource> lro = await dataMaskingPolicy.UpdateAsync(WaitUntil.Completed, data); DataMaskingPolicyResource result = lro.Value; // the variable result is a resource, you could call other operations on this instance as well // but just for demo, we get its data from this resource instance DataMaskingPolicyData resourceData = result.Data; // for demo we just print out the id Console.WriteLine($"Succeeded on id: {resourceData.Id}"); 

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-6852/providers/Microsoft.Sql/servers/sqlcrudtest-2080/databases/sqlcrudtest-331/dataMaskingPolicies/Default?api-version=2023-08-01 { "properties": { "dataMaskingState": "Enabled" } } 

using Azure; using Azure.ResourceManager; using System; using System.Threading.Tasks; using Azure.Core; using Azure.Identity; using Azure.ResourceManager.Sql.Models; using Azure.ResourceManager.Sql; // Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/stable/2023-08-01/examples/DataMaskingPolicyCreateOrUpdateMin.json // this example is just showing the usage of "DataMaskingPolicies_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately. // get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line TokenCredential cred = new DefaultAzureCredential(); // authenticate your client ArmClient client = new ArmClient(cred); // this example assumes you already have this DataMaskingPolicyResource created on azure // for more information of creating DataMaskingPolicyResource, please refer to the document of DataMaskingPolicyResource string subscriptionId = "00000000-1111-2222-3333-444444444444"; string resourceGroupName = "sqlcrudtest-6852"; string serverName = "sqlcrudtest-2080"; string databaseName = "sqlcrudtest-331"; DataMaskingPolicyName dataMaskingPolicyName = DataMaskingPolicyName.Default; ResourceIdentifier dataMaskingPolicyResourceId = DataMaskingPolicyResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName, databaseName, dataMaskingPolicyName); DataMaskingPolicyResource dataMaskingPolicy = client.GetDataMaskingPolicyResource(dataMaskingPolicyResourceId); // invoke the operation DataMaskingPolicyData data = new DataMaskingPolicyData { DataMaskingState = DataMaskingState.Enabled, }; ArmOperation<DataMaskingPolicyResource> lro = await dataMaskingPolicy.UpdateAsync(WaitUntil.Completed, data); DataMaskingPolicyResource result = lro.Value; // the variable result is a resource, you could call other operations on this instance as well // but just for demo, we get its data from this resource instance DataMaskingPolicyData resourceData = result.Data; // for demo we just print out the id Console.WriteLine($"Succeeded on id: {resourceData.Id}"); 

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue