How can I allow unknown users to access my SQL (Azure) DB?

Question

Apparently one must explicitly specify (whitelist) the IP addresses that will be allowed access to a SQL Azure DB. I want, though, to have N-gazillion* users that will access these tables for data specific to them.

Will these need to first provide me with their IP address so that I can add it as a valid entry, or is there a programmatic way to do it, or some other workaround?

Answer 1

Go to your Server and click on Show firewall settings and add the following rule:

Comments

thankssssssssssssss