If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Read-access for public or for dynamic IP?

We work with a company that wants to host some of our listings on their website, but we use a database and they don't have a "dedicated IP" like we do, so I can't just put their IP in the "safe" list...

In general, you want to avoid allowing database connections from any IP address. Build a simple web service or page to relay the needed records in a JSON, XML, or CSV format, over SSL, if desired, and contingent on some agreed upon access key (or "password").

There is a third option:
If your network admin familiar with VPN you can allow them authorized access to your database via VPN connection.
And yet you will need specific user with read only access.
Because even over super secure connection you do not want anyone connect to your database server and mess with unintended data.
But if they need just to read data to show on their site why not give them something like JavaScript widget hosted on your site to display your data?
Or that can be achieved by web service to throw all data in XML format at authorized request...

There is a third option:
If your network admin familiar with VPN you can allow them authorized access to your database via VPN connection.
And yet you will need specific user with read only access.
Because even over super secure connection you do not want anyone connect to your database server and mess with unintended data.

Unless you're a developer telecommuting from home over VPN. (Okay, excuse me while I get back to work... )

"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation