Section Access

[ramananramaraj]

Qliksense - Data Row level Security 

We have a Filter called Department(Dimension)  Which has values as Mentioned below:

IT

Mechanical

Admin

While we try to implement the Section Access for a particular user(Ex: User RR1234  Via Section access it is not restricting the data)

EX: RR1234 User should not get the option to filter Admin in the department column.Please advise.

Section Access;

Load * Inline [
ACCESS, USERID, DEPT,SHEET1,SHEET2
USER, DOMAIN\RR1234,ADMIN,0,0
ADMIN, DOMAIN\RR3213,*,*,1
USER, DOMAIN\RR4321,MECHANICAL,1,1
];

Section Application;

[martinpohl]

so you need:

Section Access;

Load * Inline [
ACCESS, USERID, DEPT,SHEET1,SHEET2
USER, DOMAIN\RR1234,IT,0,0

USER, DOMAIN\RR1234,MECHANICAL,0,0

ADMIN, DOMAIN\RR3213,*,*,1
USER, DOMAIN\RR4321,MECHANICAL,1,1
];

also, your data model needs a field DEPT which is

upper(Department) as DEPT

section access requires upper field names and upper values.

Regards

[ramananramaraj]

Yes Bro.I kept both(Section and my main table) the fields as UPPER(DEPT) still it doesn't turn-on.