topic Re: Security Rules different to each user in App Development

Security Rules different to each user

charlie2 — Mon, 06 Dec 2021 08:12:35 GMT

Hi,

I have a question on security rules for qlik sense.

I have a field in my data called NodeID. This NodeID is used as filter to limit the access to the data of the app to each user.

I upload the following table for the security rules:

NodeID	ACCESS	USERID
2760110	USER	a
2760101	USER	b
2760102	ADMIN	c

with this formula:

Section Access;
Load
ACCESS,
UPPER(USERID) AS USERID,
NodeID
FROM [xyz]
(ooxml, embedded labels, table is Sheet1);
Section Application;

For the first two users, the security rules work without any problem. They are limited to their NodeID. However, for th e last one (2760102), I would like this user to have access to everything within the App. How can I link it and still have access to all the data?

I would assume an extra field is needed. If I remove the NodeID and substitute it for a star (*), then the link is not created and his/her userid disappears from the field.

Thanks for the support in advance

Re: Security Rules different to each user

RaduM — Mon, 06 Dec 2021 10:42:51 GMT

can you try to add an extra row?

NodeID	ACCESS	USERID
2760110	USER	a
2760101	USER	b
2760102	ADMIN	c
*	ADMIN	c

Re: Security Rules different to each user

anat — Mon, 06 Dec 2021 10:43:45 GMT

u can create one more dummy user and use * for ADMIN

SECTION ACCESS;

LOAD * Inline [
ACCESS,USERID,NID
USER,A,2760110
USER,B,2760101
USER,D,2760102
ADMIN,C,*

];
SECTION APPLICATION;
LOAD * Inline [
NID,id
2760110,1
2760101,2
2760102,3
];

Re: Security Rules different to each user

charlie2 — Mon, 06 Dec 2021 10:48:39 GMT

Hi @RaduM ,

Thanks a lot. Adding an extra line works!

Re: Security Rules different to each user

RaduM — Mon, 06 Dec 2021 10:50:34 GMT

Glad to be helpful