Hi All
I have multiple tables in my app pertaining to different domains. I need help in providing Section Access.
Data related to Table1 should be given access as follows :
- Only Site Head should be able to view respective site details.
- Within a site, only department head should be able to see his span details.
I was able to close this using this structure:
ACCESS USERID SITE Manager_ID
Admin ABX\123 * *
User ABX\234 A * // Site Manager
User ABX\412 A 412 // Department Manager
Now I have data pertaining to other verticals in a separate table.
After using the above Section Access , I am not able to see data from other tables.
Suppose Table2 has a field called GEOID with same values across table , then I tried using :
ACCESS USERID SITE Manager_ID GEOID
Admin ABX\123 * *
User ABX\234 A * // Site Manager
User ABX\412 A 412 // Department Manager
But, this did not work.
Please let me know in case I have missed out something in forming the structure.
