Section Access Help - Data Reduction

[tahirkhalil]

I have a case - in section access I have following entries:

USER NTNAME ZoneLevel

ADMIN, *, *

USER, TEST1, SOUTH

USER, TEST2, NORTH

USER, TEST3, CENTRAL

How is it possible to give access to a new user TEST4 for both SOUTH & NORTH?

Regards,

Tahir

[oknotsen]

Remove ZoneLevel from the Section Access table and instead add a Profile column.

Make a new (inline) table called "AccessProfile" in which you combine Profile with ZoneLevel.

You can now add multiple lines in this "AccessProfile" table, one for every ZoneLevel you want to give someone access to.

[sasikanth]

hi,

Try Some thing like this,

Section Access;

Load * INLINE [

USER ,NTNAME 

ADMIN,TEST

USER, TEST1

USER, TEST2

USER, TEST3

USER,TEST4

USER,TEST5

];

load Another table

LOAD * INLINE [

NTNAME,ZONELEVEL

TEST1,SOUTH

TEST2,NORTH

TEST3,CENTRAL

TEST4,SOUTH

TEST4,NORTH

];

Section Application;

[hic · Accepted solution]

... or just add TEST4 on two lines:

ADMIN, *, *

USER, TEST1, SOUTH

USER, TEST2, NORTH

USER, TEST3, CENTRAL

USER, TEST4, SOUTH

USER, TEST4, NORTH

HIC

[tahirkhalil]

Hi Onno

Please see the attached QV doc.

The section access is not working - no idea why?

Hidden script password is 123

This is hidden script:

STAR IS *;

Section Access;

LOAD * INLINE [

    ACCESS, USERID, AccessProfile

    ADMIN, USER1, PROFILEC

    USER, USER2, PROFILEN

    USER, USER3, PROFILES

];

Section Application;

[AccessProfile]:

LOAD * INLINE [

    Zone, AccessProfile

    CENTRAL, PROFILEC

    NORTH, PROFILEN

    SOUTH, PROFILES

];

STAR IS ;

[oknotsen]

Hi,

IIRC the name of all the columns in the section access table need to be in ALL CAPS.

So AccessProfile should be ACCESSPROFILE.

[tahirkhalil]

Thank you - I missed that

Thanks for your help.