Refer below link for Section Access.
Don't forget to add internal user of Scheduler in list of user as ADMIN.(internal\sa_scheduler).
I hope this is helpful.
rittermd are you referring to the usage of internal\sa_scheduler? Or that it needs to be an ADMIN?
internal\sa_scheduler is the user used by the reload engine to access the app during reload.
A person with ADMIN privileges has access to all data in the app. For this reason the reloading user should be an ADMIN user. The online help unfortunately refers to the internal\sa_scheduler with USER level ACCESS. This will be corrected in coming releases of help, to clarify that ACCESS must be set as ADMIN.
Please let me know your requirement I will write the logic for you..
as a sample please find my logic for cost centre section access restriction to the cost centre managers:
UPPER("Access") AS ACCESS,
UPPER("Userid") AS USERID,
FROM [lib://QS_Cost_Center (opd_f29121)/Userlist.xlsx]
(ooxml, embedded labels, table is [Master OPD List]);
(OPD&USERID) AS USERID,
UPPER("Cost Centre Number") as [COST CENTRE],
"Cost Centre Manager" AS Fullname
FROM [lib://QS_Cost_Center (opd_f29121)/Copy of Cost Centre Hierarchy - CURRENT 22.06.16.xlsx]
(ooxml, embedded labels, table is [SAP Hierarchy]);
LOAD * inline [
ACCESS, USERID,COST CENTRE
star is *;
Load * Resident TMP3;
drop table TMP1;
drop table TMP2;
drop table TMP3;