Multi Tenancy

[jcrick]

Hi
What is the best way to implement multi-tenancy in ASP Net Maker?

Thanks, Jerry

[motfs]

multi-tenancy

If you want to handle different account/customer to access database, you may use User Level Security or User ID Security. See Security Settings -> User ID Security/User Level Security in help file for more details

[jcrick]

I understand table and record level security but the implementation is not at all clear.

In my scenario I will create a Customer table with an ID.

All other tables will include the CustomerID.

A user will register as an employee of exactly 1 Customer.

That user must only be able to see records where the CustomerID is the same as the employee's CustomerID.

I just cannot see how this is implemented - any thoughts please?

Many thanks, Jerry

[motfs]

You can view this topic link for more info:
http://www.hkvforums.com/viewtopic.php?f=4&t=36121

[jcrick]

Hi

I am using User ID security to make sure users only see data related to their own company, which works fine. But how do I stop them from seeing employee data for employees in their own company?

I think I need to add some extra custom security checks?

Many thanks, Jerry

[jcrick]

This is now working.

The solution was to use User ID security, make sure User level security is disabled, make sure in Advanced Security \ User ID that all 'Allow View All' tickboxes are unticked.

Thanks, Jerry