如何允许未知用户访问我的SQL(Azure)数据库? [英] How can I allow unknown users to access my SQL (Azure) DB?

问题描述

显然，必须明确指定(白名单)将被允许访问SQL Azure DB的IP地址.不过，我希望有N-gazillion *用户可以访问这些表以获取特定于它们的数据.

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.

• 宏伟/大妄想症的妄想

这些需要首先为我提供其IP地址，以便我可以将其添加为有效条目吗?或者是否有编程方式来实现它，或者有其他解决方法?

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?

推荐答案

建议让某种中间件访问数据库，而不是直接访问客户端.

It would be advisable to have some sort of middle ware access the db and not your clients directly.

但是，如果您希望任何IP能够连接到数据库，只需将此条目添加到防火墙列表中即可:

However if you want any IP to be able to connect to the db just add this entry to the firewall list:

Azure门户->数据库->服务器->配置并添加以下规则:

Azure Portal -> Databases -> Servers -> Configure and add the following rule:

这篇关于如何允许未知用户访问我的SQL(Azure)数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！