topic Re: Section Access Security through Active directory Group in QlikView

Section Access Security through Active directory Group

arsal_90 — Mon, 14 Apr 2014 18:43:10 GMT

Hi all

i have a qlikview document named: abc.qvw and i have to assign security through active directory groups. let say i have made 3 active directory group. 1 group has right to north region and second one to south and third one to West. So how can i maintain section access through active directory. and i have only qlikview server. Please share how to apply section access security through active directory.

Thanks in advance

Arsalan

Re: Section Access Security through Active directory Group

fkeuroglian — Mon, 14 Apr 2014 19:50:14 GMT

Hi, why you cant use section access in the script? why use in the ad?

if you use section access in the script and use data reduction you can get all the thing that you want,

1 group will see only the north , other the south and the other the west.

see the attached

Sheets Security with Section Access

Section access and data reduction - ADMIN user has data reduced

One Qlik at a Time: Section access - part one (including inline wizard)

good luck

Fernando

Re: Section Access Security through Active directory Group

maxgro — Mon, 14 Apr 2014 19:51:44 GMT

If I understand your request I think you can use the AD group in NTNAME field in a similar way

SECTION Access;

LOAD * INLINE [

ACCESS, NTNAME, REGION

USER, DOMAIN\AD_GROUP_1, NORTH

USER, DOMAIN\AD_GROUP_2, SOUTH

USER, DOMAIN\AD_GROUP_3, WEST

];

Section Application;

Table:

load * inline [

REGION, Value

NORTH,1

SOUTH,2

SOUTH, 3

WEST, 4

];

Re: Section Access Security through Active directory Group

SunilChauhan — Tue, 15 Apr 2014 06:53:56 GMT

Take one excel and write
Access NTNAME REGION

made ur entries here

and load it into

section access

Load

Upper(Access) as Access

upper(NTNAME) as NTNAME,

upper(REGION) as REGION

from excel path

section application;

now use Brij Dijks step

and reload app and check

hope this helps

Re: Section Access Security through Active directory Group

arsal_90 — Tue, 15 Apr 2014 08:04:23 GMT

Thanks Sunil and Thanks Bert

Is there nothing special to do on QEMC?

Re: Section Access Security through Active directory Group

maxgro — Tue, 15 Apr 2014 09:45:19 GMT

for testing in qlikview desktop I think that's all (me too I tried the script I posted on my pc with qlikview desktop)

for server

users need qlikview licenses

user must be authorized to qlikview docs

users must be in active directory group (setup in windows); this is true also for test with qlikview desktop

and also if I'm not wrong you have to add to section access the user (server service) that reloads the docs

Re: Section Access Security through Active directory Group

stabben23 — Tue, 15 Apr 2014 21:14:09 GMT

Hi,

add the service account who runs the services at QVS as Admin in your section Access Table.

Re: Section Access Security through Active directory Group

SunilChauhan — Wed, 16 Apr 2014 05:22:39 GMT

Hi ,

here we have nothing to do with Qmec.

using above we are running application without any error

thanks