Managed Database Vulnerability Assessment Rule Baselines - Delete

Reference

Service:: SQL Database

API Version:: 2021-11-01

Removes the database's vulnerability assessment rule baseline.

DELETE https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/databases/{databaseName}/vulnerabilityAssessments/default/rules/{ruleId}/baselines/{baselineName}?api-version=2021-11-01

URI Parameters

Name	In	Required	Type	Description
baselineName	path	True	VulnerabilityAssessmentPolicyBaselineName	The name of the vulnerability assessment rule baseline (default implies a baseline on a database level rule and master for server level rule).
databaseName	path	True	string	The name of the database for which the vulnerability assessment rule baseline is defined.
managedInstanceName	path	True	string	The name of the managed instance.
resourceGroupName	path	True	string	The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
ruleId	path	True	string	The vulnerability assessment rule ID.
subscriptionId	path	True	string	The subscription ID that identifies an Azure subscription.
vulnerabilityAssessmentName	path	True	VulnerabilityAssessmentName	The name of the vulnerability assessment.
api-version	query	True	string	The API version to use for the request.

Responses

Name	Type	Description
200 OK		Successfully removed the database vulnerability assessment rule baseline.
Other Status Codes		* Error Responses: * 400 VulnerabilityAssessmentStorageAuthenticationFailed - Could not authenticate to storage account '{0}' . 400 VulnerabilityAssessmentInvalidPolicy - Vulnerability Assessment settings don't exist or invalid storage specified in settings. 400 VulnerabilityAssessmentDatawarehouseDatabaseIsDeactivated - Could not execute Vulnerability Assessment operation because the database is paused. Please resume it. 400 VulnerabilityAssessmentStorageOutboundFirewallNotAllowed - The storage account is not in the list of Outbound Firewall Rules. 400 InvalidVulnerabilityAssessmentOperationRequest - The vulnerability assessment operation request does not exist or has no properties object. 400 DataSecurityInvalidUserSuppliedParameter - An invalid parameter value was provided by the client. 404 VulnerabilityAssessmentInvalidStorageAccount - The storage account '{0}' that was defined in the policy is invalid. 404 SubscriptionDoesNotHaveServer - The requested server was not found 404 SourceDatabaseNotFound - The source database does not exist. 404 DatabaseDoesNotExist - User has specified a database name that does not exist on this server instance. 404 VulnerabilityAssessmentRuleDoesNotExists - Rule '{0}' does not exist. 404 VulnerabilityAssessmentBaselineDoesNotExists - Baseline does not exist for rule '{0}' 500 DatabaseIsUnavailable - Loading failed. Please try again later.

Name

Type

Description

200 OK

Successfully removed the database vulnerability assessment rule baseline.

Other Status Codes

*** Error Responses: ***

400 VulnerabilityAssessmentStorageAuthenticationFailed - Could not authenticate to storage account '{0}' .
400 VulnerabilityAssessmentInvalidPolicy - Vulnerability Assessment settings don't exist or invalid storage specified in settings.
400 VulnerabilityAssessmentDatawarehouseDatabaseIsDeactivated - Could not execute Vulnerability Assessment operation because the database is paused. Please resume it.
400 VulnerabilityAssessmentStorageOutboundFirewallNotAllowed - The storage account is not in the list of Outbound Firewall Rules.
400 InvalidVulnerabilityAssessmentOperationRequest - The vulnerability assessment operation request does not exist or has no properties object.
400 DataSecurityInvalidUserSuppliedParameter - An invalid parameter value was provided by the client.
404 VulnerabilityAssessmentInvalidStorageAccount - The storage account '{0}' that was defined in the policy is invalid.
404 SubscriptionDoesNotHaveServer - The requested server was not found
404 SourceDatabaseNotFound - The source database does not exist.
404 DatabaseDoesNotExist - User has specified a database name that does not exist on this server instance.
404 VulnerabilityAssessmentRuleDoesNotExists - Rule '{0}' does not exist.
404 VulnerabilityAssessmentBaselineDoesNotExists - Baseline does not exist for rule '{0}'
500 DatabaseIsUnavailable - Loading failed. Please try again later.

Examples

Removes a database's vulnerability assessment rule baseline.

DELETE https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/vulnerabilityaseessmenttest-4799/providers/Microsoft.Sql/managedInstances/vulnerabilityaseessmenttest-6440/databases/testdb/vulnerabilityAssessments/default/rules/VA1001/baselines/default?api-version=2021-11-01


import com.azure.resourcemanager.sql.models.VulnerabilityAssessmentName;
import com.azure.resourcemanager.sql.models.VulnerabilityAssessmentPolicyBaselineName;

/**
 * Samples for ManagedDatabaseVulnerabilityAssessmentRuleBaselines Delete.
 */
public final class Main {
    /*
     * x-ms-original-file: specification/sql/resource-manager/Microsoft.Sql/stable/2021-11-01/examples/
     * ManagedDatabaseVulnerabilityAssessmentRuleBaselineDelete.json
     */
    /**
     * Sample code: Removes a database's vulnerability assessment rule baseline.
     * 
     * @param azure The entry point for accessing resource management APIs in Azure.
     */
    public static void
        removesADatabaseSVulnerabilityAssessmentRuleBaseline(com.azure.resourcemanager.AzureResourceManager azure) {
        azure.sqlServers().manager().serviceClient().getManagedDatabaseVulnerabilityAssessmentRuleBaselines()
            .deleteWithResponse("vulnerabilityaseessmenttest-4799", "vulnerabilityaseessmenttest-6440", "testdb",
                VulnerabilityAssessmentName.DEFAULT, "VA1001", VulnerabilityAssessmentPolicyBaselineName.DEFAULT,
                com.azure.core.util.Context.NONE);
    }
}

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

Sample response

Status code:: 200

Definitions

Name	Description
VulnerabilityAssessmentName	The name of the vulnerability assessment.
VulnerabilityAssessmentPolicyBaselineName	The name of the vulnerability assessment rule baseline (default implies a baseline on a database level rule and master for server level rule).

VulnerabilityAssessmentName

The name of the vulnerability assessment.

Name	Type	Description
default	string

VulnerabilityAssessmentPolicyBaselineName

The name of the vulnerability assessment rule baseline (default implies a baseline on a database level rule and master for server level rule).

Name	Type	Description
default	string
master	string

Share via