Multiple Columns - Tenancy

[bazooka720]

Is it possible to allow tenancy that is based on more than 1 column ? This will significantly enhance capability

[hoppergee]

Could you offer more details about the multiple columns which can help me to dig deeper?

[bazooka720]

@hoppergee Thanks for getting back. Let's say we want tenancy established based on two attributes tenantID and clientID (assume scenario where each tenant may have multiple clients within). Ability to optionally allow scope to include more than one column can significantly enhance security

[hoppergee]

This sounds like a nest tenant(Tenant and Sub-tenant). May I ask which should the current_tenant represent to? The Tenant or the Client?

Sorry, I'm not quit sure how to start, maybe you could give more suggestions? @bazooka720

[bazooka720]

What if it's dependent on the user role? If the user is "client" type then current_tenant refers to company(subdomain)+client, else its just company

[bazooka720]

@hoppergee thoughts?