Hi all,
I have one issue while giving sheet level section access to user where I have to give ALL PLANTS access of Sheet1 to 50004579@ABC.COM and give P002,P003,P004 plants access to same user (50004579@ABC.COM )for Sheet2.
(Note: We are using different source for both sheet and later concatenated)
Section Access;
SA_TAB:
LOAD
ACCESS,
USER.EMAIL,
SHEET_CONTROLLER AS SHEET_CONTROLLER,
SUBFIELD(PLANT,'|') AS PLANT,
PLANT AS PLANT_SA
Inline
[
ACCESS, USER.EMAIL, PLANT, SHEET_CONTROLLER
ADMIN, MMKNDQLIKVIEW@ABC.COM, ALL, ALL
ADMIN, AFSQSENSEADMIN@ABC.COM, ALL, ALL
ADMIN, 50004383@ABC.COM, ALL, ALL
USER, 50004579@ABC.COM, ALL, 1
USER, 50004579@ABC.COM, P002|P003|P004, 2
];
Section Application;
Sheet_Access:
Load * Inline
[
SHEET_CONTROLLER
1
2
12
ALL
];
In sheet we have given Show condition
for Sheet1
=SHEET_CONTROLLER=1 or SHEET_CONTROLLER ='ALL'
for Sheet2
=SHEET_CONTROLLER=2 or SHEET_CONTROLLER ='ALL'
