[Enhancement]: Disable rotation on RDS managed master password

[tomthetommy]

Description

I'm using various terraform modules to configure RDS instances and would like to store the master passwords in secretsmanager. My issue is that I can't disable password rotation via terraform, there is no option. https://registry.terraform.io/providers/hashicorp/aws/5.51.0/docs/resources/db_instance

I'd like to be given the option to set a flag to disable password rotation in secrets manager.

Similar issue mentioned here https://github.com/terraform-aws-modules/terraform-aws-rds/issues/538

Affected Resource(s) and/or Data Source(s)

aws_db_resource

terraform-aws-modules/rds/aws

Potential Terraform Configuration

No response

References

No response

Would you like to implement a fix?

No

[github-actions[bot]]

Community Note

Voting for Prioritization

• Please vote on this issue by adding a 👍 reaction to the original post to help the community and maintainers prioritize this request.
• Please see our prioritization guide for information on how we prioritize.
• Please do not leave "+1" or other comments that do not add relevant new information or questions, they generate extra noise for issue followers and do not help prioritize the request.

Volunteering to Work on This Issue

• If you are interested in working on this issue, please leave a comment.
• If this would be your first contribution, please review the contribution guide.

[sadmdbrezack-metabolon]

I think we just need a new field on aws_db_instance to disable the creation of the secret rotation or leave it disabled by default.

It's not a lot of work for devs to add a aws_secretsmanager_secret_rotation in post