Your Section Access Inline load isn't in upper case plus it doesn't define who holds what position and SA cannot know what to restrict and what not to?
I believe you'd need to have a separate column defining who's Manager or User
And with in section Access inline load you need to add a field which you want to restrict or show
Ex:
STAR IS *;
SECTION Access;
LOAD * INLINE [
ACCESS, UID, POSITION, SALARY, USERID, PASSWORD
ADMIN, PAVAN, MANAGER, 2000, PAVAN, 1234
ADMIN, RAFI, MANAGER, 15500, RAFI, 1234
USER, RAJESH, USER, 40000, RAJESH, 123
ADMIN, UDAY, MANAGER, 10000, UDAY, 1234
USER, NAVIN, USER, 30000, NAVIN, 123
ADMIN, , MANAGER, *, ADMIN, ABCD
];
Section Application;
The above table will restrict as per Salary so you'd either need to give the field name with all values and STAR IS *; is show all values.
So user with name ADMIN and password ABCD will see all the users including manager and their salaries.
This is not tested but it should be in this way. And when you publish it, replace the USERID and PASSWORD with NTNAME
Maybe you should have an extra field as POSITION in your Data model which will easily fetch who is what and restrict them.
