topic Re: Dynamic Section Access in QlikView

Dynamic Section Access

NavinReddy — Wed, 29 Apr 2020 10:05:44 GMT

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

Re: Dynamic Section Access

NavinReddy — Wed, 29 Apr 2020 17:19:23 GMT

can someone help me on below issue.

Re: Dynamic Section Access

Brett_Bleess — Thu, 21 May 2020 21:21:57 GMT

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