Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
with the below script, i have build the dynamic section access. now i have added my name to the excel data list. when im trying to open the application i got the " Access Denied" error message. kindly help in future any additions to the list how can i provide the access to the members. kindly help me.
/* load all the members from the network */
Data:
LOAD Source,
SID
FROM
[..\Desktop\Section Access\Output.xlsx]
(ooxml, embedded labels, table is Sheet1);
USERACCESS:
LOAD * INLINE [
ACCESS, NTNAME
ADMIN,
];
Concatenate
LOAD 'USER' AS ACCESS,
'NAEAST\'& SID as NTNAME
RESIDENT Data;
/* remove data members from memory */
Drop table Data;
/* create section access */
Section access;
Load *
Resident USERACCESS;
Section application;
Regards,
Navin
can someone help me on below issue.
I would recommend reviewing some key sources of information:
Help: https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Security.htm
Design Blog Post: https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766
Note, there are two other posts attached to the Design Blog link at the bottom related to Dynamic Data reduction, so be sure to check those too.
You may find some further useful Documents in the following search result link:
QlikView Documents area search results for 'Section Access'
About the best I can offer, really need a lot more info in order to help you troubleshoot, in these cases generally need the application with Section Access commented out such that the security table loads into the rest of the data model, so we can see how things are linked etc. I would suspect that is where things are likely going wrong, but not sure. I am also not sure what SID is in your case, generally the SID is not a friendly name, which is what we would want to be matching to, the user login ID, not their actual SID. About that best I can explain that one.
Regards,
Brett