SQL Azure 报告能否离散/不透明地支持多租户模型？
我们在一个 SQL Azure 实例中存储多个租户。我一直在做一些研究，但无法确定 SQL Azure Reporting 是否可以离散支持多租户模型。
例如，我们希望根据用户的“租户”运行报告，但我们希望租户 ID 对他们来说完全不透明——不包含在查询字符串或用户可查看的任何内容中。
以前有人遇到过这个问题吗？你的解决方案是什么？
We are storing multiple tenants in one instance of SQL Azure. I have been doing some research, but I cannot determine if SQL Azure Reporting can support a multi-tenant model discretely.
For example, we want to run reports for a user based on their "tenancy", but we want their tenant ID to be completely opaque to them- not contained in a query string, or anything view-able by the user.
Has anyone encountered this problem before? What was your solution?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
如果您有用户只能属于单个租户的限制，您可以从用户跳到相应的租户，而无需他们知道其租户 ID。因此，任何与租户相关的查询都可以由登录用户自动过滤。
If you had the restriction that a User can only belong to a single tenant, you can hop from a User to the corresponding tenant without them having to know their tenant Id. So any of your Tenant related queries could automatically be filtered by the logged-in user.