Skip to content

Instantly share code, notes, and snippets.

@DataSic

DataSic/ModifySqlDatabaseAuditing.ps1

Created June 3, 2018 14:39
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save DataSic/a0d547fae28b4acfacb7d387c92fbf49 to your computer and use it in GitHub Desktop.
Save DataSic/a0d547fae28b4acfacb7d387c92fbf49 to your computer and use it in GitHub Desktop.
Download ZIP
Modify Set-AzureRmSqlDatabaseAuditing
Raw
ModifySqlDatabaseAuditing.ps1
$AuditActionGroup = @("SUCCESSFUL_DATABASE_AUTHENTICATION_GROUP",
"FAILED_DATABASE_AUTHENTICATION_GROUP",
"BATCH_COMPLETED_GROUP",
"BACKUP_RESTORE_GROUP",
"DATABASE_OPERATION_GROUP",
"USER_CHANGE_PASSWORD_GROUP")
$setAzureRmSqlDatabaseAuditingSplat = @{
ResourceGroupName = "ResourceGroupName"
ServerName = "ServerName"
DatabaseName = "DatabaseName"
StorageAccountName = "StorageAccountName"
State = "Enabled"
AuditActionGroup = $AuditActionGroup
}
Set-AzureRmSqlDatabaseAuditing @setAzureRmSqlDatabaseAuditingSplat
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment