topic Re: Section Access in App Development

Section Access

ramananramaraj — Tue, 28 Jul 2020 11:15:17 GMT

Qliksense - Data Row level Security

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

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 — Tue, 28 Jul 2020 11:32:40 GMT

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 — Tue, 28 Jul 2020 11:47:31 GMT

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