Section Access Security through Active directory Group

[arsal_90]

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

[fkeuroglian]

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

[maxgro]

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

];

[SunilChauhan]

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

[arsal_90]

Thanks Sunil and Thanks Bert

Is there nothing special to do on QEMC?

[maxgro]

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

[stabben23]

Hi,

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

[SunilChauhan]

Hi ,

here we have nothing to do with Qmec.

using above we are running application without any error

thanks