Security Rules different to each user

[charlie2]

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

[RaduM · Accepted solution]

can you try to add an extra row?

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

[anat]

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
];

[charlie2]

Hi @RaduM ,

Thanks a lot. Adding an extra line works!

BR

[RaduM]

Glad to be helpful