section access not working properly

[ali_hijazi]

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

];

[#2]

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.

[#3]

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

[ali_hijazi]

I discovered the problem

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