Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i have used below script to build Section Access, based on SID i want to filter the data(the field on which i want to restrict data). After building the section access, i am unable to open the application it is asking user name and Password. without username and password i want to restrict the data based on OSUSER(). kindly help me
Data:
LOAD SID
FROM
[C:\Desktop\Section Access\ Output.xlsx]
(ooxml, embedded labels, table is Sheet1);
USERACCESS:
LOAD * INLINE [
ACCESS, NTNAME, NTDOMAINSID, NTSID
ADMIN, ADMIN,*,*
];
Concatenate
LOAD 'USER' AS ACCESS,
UPPER(OSUser()) as NTNAME,
UPPER(SID) as NTSID
RESIDENT Data;
drop table Data;
section access;
Load *
Resident USERACCESS;
section application;
Regards
Navin
Any Suggestions please
Here are some links that should put you on the right track with things:
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766
https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Security.htm
You can use the following link to search the 'Documents' others have written on Section Access too, just search on Section Access in the search box there, there are quite a few that should provide further information:
https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Security.htm
That all being said, unless you have multiple domains in play, you really just need the NTNAME field, you do not need the SID fields, those are really only going to be necessary if you could potentially have duplicate users across domains...
Regards,
Brett