Master/Detail cases with User ID security enabled

ASP.NET Maker General Discussion (ASP.NET Maker)
1

Greetings,

In the master/detail scenario, I know that we have to link the master’s PK with the detail’s FK so that ASPNETMAKER will automatically pick the related detail records. But when using User ID security, without linking the user id from the master to the user id in the detail, it does not work!. I don’t know if this is the case for everybody or only my project though! This gave me a hard time and I learned it by trial and error. I hope someone would tell me if the followings are correct:

  1. We put a user id column in any table in which we want the user to see only their (or their child users’) records.
  2. We must not link the users’ table (using the user id) with any other table .
  3. For the User ID security scenario, when two tables are linked as master/detail, we must have another master/detail link created using the user id’s of the tables.So there will be two links between the master/detail, one for the original field (like order id) and one for the user id.

Thanks.

2

If you have set up User ID Security for the master table, the detail table will automatically be User ID protected. You can refer to the Orders/Order Details settings in the demo project.

3

This works fine when the detail table is not a master of another detail table. But when you have master 1–>detail of 1 (master 2)–>detail 2 (like colleges–>departments–>faculty), we need user id in detail 2 (faculty table).

4

In that case, please add User ID Security to the second level of master table as well.