Section Access Issue

[Karl_Hart]

Hi, when I was testing section access it worked on a simple model - this restricted the User hartk to only be able to see "CU RR"

Section Access;

Star is *;

LOAD * INLINE [

    ACCESS, SERIAL, NTNAME, SP 12

    ADMIN, *, WCHG\QV_User,

    USER, *, WCHG\hartk, 'CU RR'

    ];

SECTION Application;

Table:

LOAD * Inline [

Property, SP 12

1, VOID

2, VOID

3, NEW

4, CU RR

5, CU RR

6, CU RR];

However, when I apply it to my actual data I cant get it to work, no matter what I try I cant get the user hartk to only be able to see data for his manager (ie MRS MANAGER)

Section Access;

Star is *;

LOAD * INLINE [

    ACCESS, SERIAL, NTNAME, FIN MANAGER

    ADMIN, *, WCHG\QV_User,

    USER, *, WCHG\hartk, 'MRS MANAGER'

    ];

SECTION Application;

Any ideas what I'm doing wrong?

Thanks.

[fkeuroglian]

Hi, do you check the "initial data reduction based in section acces"???

[Karl_Hart]

Thanks Fernando, I hadn't got that selected, it has helped narrow down the issue.

I can now apply restrictions in my main document, but only to data that I load in an inline table, but not to any of my data that I load from the QVD files.

I cant understand why!

[SunilChauhan]

use all in upper in all fields of section access on inline table

[mr_novice]

Did you add yourself as ADMIN?

Had a similar problem where all possible combinations of "SP 12" in table were not present in SA table.

[Karl_Hart · Accepted solution]

Thanks for that, it now works if I convert my source data into CAPITALS.

Is there any way around this?

[fkeuroglian]

Perfect Karl, it is a requirement to set CAPITAL leters to the field that you put in the section acces, it is a rule