CODEWITHSUNDEEP
sqlazurereportingmulti-tenant
a developer
a developer

Reputation: 423

Can SQL Azure Reporting support a multi-tenancy model discretely/opaquely?

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?

Upvotes: 0

Views: 225

Answers (1)

Michael Brown
Michael Brown

Reputation: 9153

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.

Upvotes: 1

Related Questions