azurerm_sql_server: Audit Configuration

hashicorp / terraform-provider-azurerm

Terraform provider for Azure Resource Manager

https://registry.terraform.io/providers/hashicorp/azurerm/latest/docs

Mozilla Public License 2.0

4.6k stars 4.65k forks source link

azurerm_sql_server: Audit Configuration #2217

Closed midacts closed 4 years ago

midacts commented 6 years ago

Community Note

Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do not help prioritize the request
If you are interested in working on this issue or have submitted a pull request, please leave a comment

Description

Add SQL Server audit configuration

New or Affected Resource(s)

azurerm_sql_server
azurerm_sql_database

mybayern1974 commented 5 years ago

https://github.com/Azure/azure-rest-api-specs/issues/7597 https://github.com/hashicorp/terraform/issues/23161

conork123 commented 4 years ago

Hi Guys I can see auditing is available in the azurerm_sql_database resource, but not in the azurerm_sql_serrver resource still. Will this be implemented?

Once applied at the server level it's inherited by any future DB's created. While we can enforce auditing through a DB terraform module, it would be nice to just set this once at the SQL server level.

tomjosekal commented 4 years ago

extended_auditing_policy supports only storage based auditing. What about Log Analytics and Event Hub based auditing?

ghost commented 4 years ago

This has been released in version 2.1.0 of the provider. Please see the Terraform documentation on provider versioning or reach out if you need any assistance upgrading. As an example:

provider "azurerm" {
    version = "~> 2.1.0"
}
# ... other configuration ...

ghost commented 4 years ago

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues.

If you feel this issue should be reopened, we encourage creating a new issue linking back to this one for added context. If you feel I made an error 🤖 🙉 , please reach out to my human friends 👉 hashibot-feedback@hashicorp.com. Thanks!