0
I have an Oracle instance set up in Amazon Web Services' RDS, and I want to give three users access to the database. The issue that I'm having is that the way security groups work, it seems that I can only approve specific IP's (or ranges) to have access. This instance is set up for a group project at my University, so we are not likely to have the same IP every time we connect. Is it possible to set up specific users' access to the instance, regardless of the IP they are connecting with?
The only solution I could think of was to set up an EC2 instance, and have everyone tunnel their traffic through that so that it looks like we are always coming from the same system. Since we are using the free tier of AWS, we are likely to go over if everyone is tunneling their traffic through the EC2 instance.
Ah, I didn't realize accessing database used up our bandwidth (although it does make sense). I'll look into setting up an EC2 instance in the same availability zone as the RDS instance. If we are being billed for accessing the database, it would only make sense to tunnel it through the EC2 instance anyway. Thanks! – EGr – 2013-11-23T20:14:12.247