topic section access not working properly in QlikView

section access not working properly

ali_hijazi — Wed, 22 Jun 2011 14:51:23 GMT

Hello

I added section access to my document

then after the section application I added a table that contains the USERID column

along with another column called the userGroup so as to reduce data by group per user

however with whatever user I log to the document the users are able to see all countries

please advise am I missing anything?

Section Access;

SecurityTable:

LOAD * INLINE [

ACCESS, USERID, PASSWORD, NTSID

ADMIN, *, *, S-1-5-21-3371183435-4001363924-1546668845

ADMIN, JeanDoumit, JD14, *

ADMIN, JohnnyChar, JC16, *

ADMIN, NajibNicolas, NN17,*

ADMIN, WaelGhallab, WG18, *

ADMIN, WalidMeghames, WM19, *

ADMIN, JohnnySaghbini, JS20, *

ADMIN, AssaadSaykaly, AS21, *

ADMIN, EliasSaba, ES103, *

ADMIN, alihijazi, alihijazi, S-1-5-21-1465622564-2283212318-2308919756

];

Section Application;

STAR is *;

UserGroupTable:

LOAD * Inline [

USERID, UserGroup

AntoineChar, GRAdmin

GeorgeBarakat, GRAdmin

JosephBejjani, GRAdmin

GeorgeHaddad, GRAdmin

NajibZebib, GRAdmin

MichelAlam, GrManagerLSGU

NadineKreiker, GrManagerLSGU

MilaKaram, GrManagerLSGU

LayalBarakat, GrManagerLSGU

PaulKhalil, GrManagerLSGU

JulianaBouAbboud, GrManagerLSGU

SarahTalge, GrManagerLSGU

ElieYasmine, GrSalesLG

JeanDoumit, GrSalesLG

JoeKhoury, GrSalesLG

JohnnyChar, GrSalesLG

NajibNicolas, GrSalesLG

WaelGhallab, GrSalesLG

WalidMeghammes, GrSalesLG

JohnnySaghbini, GrSalesLG

AssaadSykaly, GrSalesLG

EliasSaba, GrSalesLG

alihijazi, SM1

];

//each GRoup with company and country combination

GroupCompanyCountry:

LOAD

AutoNumber(GCompanyCountry) as GCompanyCountry,

UserGroup

Inline [

GCompanyCountry, UserGroup

GF|LB, GRAdmin

GF|SY, GRAdmin

UN|LB, GRAdmin

UN|SY, GRAdmin

GF|LB, SM1

GF|LB, GrManagerLSGU

GF|SY, GrManagerLSGU

UN|LB, GrManagerLSGU

UN|SY, GrManagerLSGU

GF|LB, GrSalesLG

];

section access not working properly

Thu, 23 Jun 2011 01:05:00 GMT

Have you tried changing all of your Access levels for users in the SecurityTable from ADMIN to USER? (Other than yourself of course). If I remember right section access will give a person access to everything if they are set to an ADMIN level.

Re: section access not working properly

Thu, 23 Jun 2011 01:43:46 GMT

Hi, everything look fine at frist look. Did you checked the Initial DataReduction Based on Session Access which you can find in Document Property--> Opening Tab. and unCheck Strict Exclusion.

Have a look at the attched application.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, ADMIN, ADMIN

ADMIN, ADM, ADM

ADMIN, AD, AD

];

Section Application;

- Sridhar

EDIT : Attachment

section access not working properly

ali_hijazi — Thu, 23 Jun 2011 10:58:20 GMT

I discovered the problem

I had to include in the section access the field userGroup written capitalized USERGROUP