< Back
Remove-AzureRmSqlDatabaseAuditing
Post
NAME Remove-AzureRmSqlDatabaseAuditing
SYNOPSIS
Removes the auditing of a database.
SYNTAX
Remove-AzureRmSqlDatabaseAuditing [-ResourceGroupName] <String> [-ServerName] <String> [-DatabaseName] <String> [-DefaultProfile
<IAzureContextContainer>] [-PassThru] [-Confirm] [-WhatIf] [<CommonParameters>]
DESCRIPTION
The Remove-AzureRmSqlDatabaseAuditing cmdlet removes the auditing of an Azure SQL database. To use this cmdlet, use the ResourceGroupName ,
ServerName , and DatabaseName parameters to identify the database. After you run this cmdlet, auditing of the database is not performed. If the
command succeeds and you have used the PassThru parameter, the cmdlet returns an object that describes the current auditing policy, in addition to
the database identifiers. Database identifiers include, but are not limited to, the ResourceGroupName , ServerName and DatabaseName .
If you remove auditing of an Azure SQL database, threat detection is also removed.
This cmdlet is also supported by the SQL Server Stretch Database service on Azure.
PARAMETERS
-DatabaseName <String>
Specifies the name of the database.
Required? true
Position? 2
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-DefaultProfile <IAzureContextContainer>
The credentials, account, tenant, and subscription used for communication with azure
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-PassThru [<SwitchParameter>]
Returns an object representing the item with which you are working. By default, this cmdlet does not generate any output.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
-ResourceGroupName <String>
Specifies the name of the resource group containing the database.
Required? true
Position? 0
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ServerName <String>
Specifies the name of the server containing the database.
Required? true
Position? 1
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-Confirm [<SwitchParameter>]
Prompts you for confirmation before running the cmdlet.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
-WhatIf [<SwitchParameter>]
Shows what would happen if the cmdlet runs. The cmdlet is not run.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (http://go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
Microsoft.Azure.Commands.Sql.Security.Model.DatabaseAuditingPolicyModel
OUTPUTS
Microsoft.Azure.Commands.Sql.Security.Model.DatabaseAuditingPolicyModel
NOTES
Example 1: Remove the auditing of an Azure SQL database
PS C:\\>Remove-AzureRmSqlDatabaseAuditing -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -DatabaseName "Database01"
This command removes the auditing of database named Database01. That database is located on Server01, which is assigned to the resource group
named ResourceGroup01.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... seauditing
Get-AzureRmSqlDatabaseAuditingPolicy
Set-AzureRmSqlDatabaseAuditingPolicy
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/
SYNOPSIS
Removes the auditing of a database.
SYNTAX
Remove-AzureRmSqlDatabaseAuditing [-ResourceGroupName] <String> [-ServerName] <String> [-DatabaseName] <String> [-DefaultProfile
<IAzureContextContainer>] [-PassThru] [-Confirm] [-WhatIf] [<CommonParameters>]
DESCRIPTION
The Remove-AzureRmSqlDatabaseAuditing cmdlet removes the auditing of an Azure SQL database. To use this cmdlet, use the ResourceGroupName ,
ServerName , and DatabaseName parameters to identify the database. After you run this cmdlet, auditing of the database is not performed. If the
command succeeds and you have used the PassThru parameter, the cmdlet returns an object that describes the current auditing policy, in addition to
the database identifiers. Database identifiers include, but are not limited to, the ResourceGroupName , ServerName and DatabaseName .
If you remove auditing of an Azure SQL database, threat detection is also removed.
This cmdlet is also supported by the SQL Server Stretch Database service on Azure.
PARAMETERS
-DatabaseName <String>
Specifies the name of the database.
Required? true
Position? 2
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-DefaultProfile <IAzureContextContainer>
The credentials, account, tenant, and subscription used for communication with azure
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-PassThru [<SwitchParameter>]
Returns an object representing the item with which you are working. By default, this cmdlet does not generate any output.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
-ResourceGroupName <String>
Specifies the name of the resource group containing the database.
Required? true
Position? 0
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ServerName <String>
Specifies the name of the server containing the database.
Required? true
Position? 1
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-Confirm [<SwitchParameter>]
Prompts you for confirmation before running the cmdlet.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
-WhatIf [<SwitchParameter>]
Shows what would happen if the cmdlet runs. The cmdlet is not run.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (http://go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
Microsoft.Azure.Commands.Sql.Security.Model.DatabaseAuditingPolicyModel
OUTPUTS
Microsoft.Azure.Commands.Sql.Security.Model.DatabaseAuditingPolicyModel
NOTES
Example 1: Remove the auditing of an Azure SQL database
PS C:\\>Remove-AzureRmSqlDatabaseAuditing -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -DatabaseName "Database01"
This command removes the auditing of database named Database01. That database is located on Server01, which is assigned to the resource group
named ResourceGroup01.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... seauditing
Get-AzureRmSqlDatabaseAuditingPolicy
Set-AzureRmSqlDatabaseAuditingPolicy
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/