topic Re: Section Access in QlikView

Section Access

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

I wanted to know how do i create a section Access using NT name .. Users access the application thorugh Access Point
at sheet level . ( i don't want to assign the users password , it should happen through there NT name user id and password )
Can someone please help with the steps

Tahnks in Advance

Re: Section Access

martinpohl — Thu, 17 Oct 2019 09:34:30 GMT

create a new sheet

go to tab general of the tab

edit show condition

=match(upper(osuser()),'DOMAIN\USER1','DOMAIN\USER2')

Regards

Re: Section Access

smilingjohn — Thu, 17 Oct 2019 09:48:51 GMT

Hi Martinphol

Thanls for the reply .I really did not understood , can you please give me one example it will be really helpfull for me .

I have never created a section access beofre . Users are access the developed dashboard trough Access Point .

Tahnks

Re: Section Access

martinpohl — Thu, 17 Oct 2019 10:04:01 GMT

I didn't meant to realize sheet access by section access.

for that

section access;

load * inline [

ACCESS, NTNAME, SHEET

ADMIN, DOMAIN\USER1, A

ADMIN, DOMAIN\USER2, A

ADMIN, DOMAIN\USER2, B

];

section application,

on the sheet, show condition

=substringcount(SHEET,'B') = 1

also enable on tab open under document properties reduce data on opening using section access

Remember that it only works after opening the sheet. after reload all datas for all users are in.

Also, don't forget to add service account to reload application

Regards

Re: Section Access

smilingjohn — Thu, 17 Oct 2019 10:11:09 GMT

Hi Martinpohl,

What is service account ?

Within the script I need to add only this much right ? and change my domain . Can i also give SHeet ,1,2,3,4,?

section access;

load * inline [

ACCESS, NTNAME, SHEET

ADMIN, DOMAIN\USER1, A

ADMIN, DOMAIN\USER2, A

ADMIN, DOMAIN\USER2, B

];

Thanks

Re: Section Access

Brett_Bleess — Wed, 23 Oct 2019 18:33:43 GMT

John, see the below links, pretty sure they should get you well on your way:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Security.htm

Regards,
Brett