Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i am playing with Omit Groups in section Access. I am trying to restrict access to particular field using omit groups depending on roles admin and users .
Here is my sample .
Section Access;
Access:
LOAD * INLINE [
ACCESS, USERID, PASSWORD, OMITGROUP
ADMIN, admin, admin,
USER, user1, user1,
USER, user2, user2, SALARYONLY
USER, user3, user3, SALARYANDABSENCE
USER, user4, user4, ABSENCEONLY
];
OmitGroups:
LOAD * INLINE [
OMITGROUP, OMIT
SALARYONLY, Salary
SALARYANDABSENCE, Salary
SALARYANDABSENCE, Absence
ABSENCEONLY, Absence
];
Section Application;
//Employees:
LOAD * INLINE [
EmpID, Name, Salary, Absence
1, Joe Bloggs, 50000, 3
2, Jane Doe, 45000, 5
3, Fred Frank, 30000, 0
4, Jeri Jublek, 19000, 12
];
I have restricted the access to Salary field for 'user2 '.But if i login with user2 credentials i can see all the data what admin can view .
Please clarify me
Thanks
Did you tick "Initial Data Reduction..."?
Try with:
Section Access;
Access:
LOAD * INLINE [
ACCESS, USERID, PASSWORD, OMIT
ADMIN, admin, admin,
USER, user1, user1,
USER, user2, user2, Salary
USER, user3, user3, Salary
USER, user3, user3, Absence
USER, user4, user4, Absence
];
Let me know
Hi, try this:
Section Access;
Access:
LOAD * INLINE [
ACCESS, USERID, PASSWORD, OMIT
ADMIN, admin, admin,
USER, user1, user1,
USER, user2, user2, Salary
USER, user3, user3, Salary
USER, user3, user3, Absence,
USER, user4, user4, Absence
];
KR
I think the OMIT field has to be part of the Section Access table itself.
It's not working .The same result what i got
Thanks
Send all the script related to section access ...
Did you tick "Initial Data Reduction..."?
Thank you !! Working fine