Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
];
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
Thanks Sunil and Thanks Bert
Is there nothing special to do on QEMC?
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
Hi,
add the service account who runs the services at QVS as Admin in your section Access Table.
Hi ,
here we have nothing to do with Qmec.
using above we are running application without any error
thanks