www.hkvforums.com

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

Thanks, Jerry

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

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

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

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

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