Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Can any one tell how to write script for section access for large number of user.
For me the concern is password, do we need to create for every user and pass it to them
Regards
Manu
Hey Manu,
You can used Active directory (NTNAME) in section access instead of user name and password where you don't need password.
For ex.
Section Access;
LOAD * INLINE [
ACCESS, NTNAME, REDUCTION
ADMIN, ADMIN,4
USER, USER,5
];
Section Application;
T1:
LOAD *,
NUM AS REDUCTION;
LOAD
Chr( RecNo()+ord('A')-1) AS ALPHA,
RecNo() AS NUM
AUTOGENERATE 3;
Can you please explain the section application script
REDUCTION is field from dataset on which you want to apply section access.
Dont forgot to check Data reduction and strict exclusion from Document Setting>> Opening.
Go through below link for more details,
https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Security.htm