We have a java application running in a Fargate container and this application needs to connect and have limited access to the Aurora Postgesql DB.
How can this java application connect to Aurora Postgres DB?
I thought of creating a user account within the db and assigning policies but I need this to be done using Terraform.
Is my approach right? if yes how do we create a user account in Aurora Postgresql db using Terraform.