I'm analysing some system role based permissions, to understand and display which users have access to which permissions and perform a comparison.
The way the data has been presented to me so far is such that I have one table that presents permissions mapped into groups permission profiles (many to many) - Table 1 and another where I have all of the base user roles mapped to permission profiles - Table 2.
I’m trying To figure out the most efficient way now to display permissions mapped to roles as in (Table 3);
e.g of tables, this is where I am now
<tbody>
</tbody>
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]
[/FONT][/FONT][/FONT]
<tbody>
</tbody>
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]This is where I want to be; so table 3 would look up the role, reference table 1 to obtain which permission profiles this role should have, then reference table 2 to obtain the individual permission items and mark them in table 3.
[/FONT][/FONT][/FONT]
<tbody>
</tbody>
The way the data has been presented to me so far is such that I have one table that presents permissions mapped into groups permission profiles (many to many) - Table 1 and another where I have all of the base user roles mapped to permission profiles - Table 2.
I’m trying To figure out the most efficient way now to display permissions mapped to roles as in (Table 3);
e.g of tables, this is where I am now
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Table 1 [/FONT][/FONT] | ||||||
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 1 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 2 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 3 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 4 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 5 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 6 [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 1 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 2 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 3 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 4 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 5 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 6 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 7 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 8 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] |
<tbody>
</tbody>
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]
[/FONT][/FONT][/FONT]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Table 2[/FONT][/FONT] | ||||||||
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 1[/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 2[/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 3[/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 4[/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 5[/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 6[/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 7[/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 8 [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 1[/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x[/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][/FONT] [/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][/FONT] [/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x[/FONT] [/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][/FONT] [/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x[/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 2 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 3 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 4 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 5 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 6 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 7 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 8 [/FONT] [/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 9 [/FONT] [/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 10 [/FONT] [/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 11 [/FONT] [/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] |
<tbody>
</tbody>
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]This is where I want to be; so table 3 would look up the role, reference table 1 to obtain which permission profiles this role should have, then reference table 2 to obtain the individual permission items and mark them in table 3.
[/FONT][/FONT][/FONT]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Table 3 [/FONT][/FONT] | ||||||
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 1 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 2 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 3 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 4 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 5 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 6 [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 1 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 2 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 3 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 4 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 5 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 6 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 7 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 8 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 9 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 10 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] |
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 11 [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x [/FONT][/FONT] | [FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] [/FONT][/FONT] |
<tbody>
</tbody>