Section Access with hyerarchical fields!!!

[#1]

Hi all,

i have a problem with this section access and this fields:

Hierarchy= L1 -> L2 -> L3

- ADMIN can view all

- JOHN can view only K/A and his childrens(K/A-1, K/A-1F, K/A-2, ...)

- JACK can view only K/B and his childrens(K/B-1, K/B-1U, K/B-6, ...)

- TIM can view only K/C-5 and his childrens(K/C-5, K/C-5T, K/C-5S)

- KARL can view only K/B-6P

I try this:

SECTION ACCESS;

star is *;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, L1, L2, L3

ADMIN, ADMIN, ADMIN

USER, JOHN, DEF, K/A, *, *

USER, JACK, YPA, K/B, *, *

USER, TIM, YYE, K/C, K/C-5, *

USER, KARL, RWE, K/B, K/B-6, K/B-6P

];

SECTION APPLICATION;

but it works only for KARL's access!

What is wrong?

Thank You all

MC

[Anonymous · Accepted solution]

Try this, nothing instread of *:

SECTION ACCESS;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, L1, L2, L3

ADMIN, ADMIN, ADMIN,   ,  ,

USER, JOHN, DEF, K/A,  , 

USER, JACK, YPA, K/B,  ,

USER, TIM, YYE, K/C, K/C-5,

USER, KARL, RWE, K/B, K/B-6, K/B-6P

];

SECTION APPLICATION;