Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Section Access issue

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

2 Replies
Highlighted
Creator II
Creator II

Any Suggestions please 

Highlighted
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.