We have sql db on RDS instance on aws. There is web application hosted on EC2 that has access to sql db. We also access this db from our office. Since we do not have our own static ip for our office, we had to made RDS instance to be accessed from any IP address, so that we can connect to this instance for work. If we had static IP, we would have given access to our IP only.
Question here is how can be make sure that this db is secure & not venerable to security threats? Is there a way we can secure this without purchasing static IP for our office?
Apparently, any db which is accessible from any location of the world is open for attacks.
We have spent a week trying to google & find some solution, but no success yet.