topic Re: Section Access issue in QlikView

Section Access issue

NavinReddy — Mon, 11 May 2020 15:22:16 GMT

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

Re: Section Access issue

NavinReddy — Tue, 12 May 2020 07:34:05 GMT

Any Suggestions please

Re: Section Access issue

Brett_Bleess — Thu, 04 Jun 2020 16:22:27 GMT

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