Section Access - USER access is denied for specific users

[Nithin29]

 - this is my user id

My section access script is not working for specfic users - they are getting access denied if set the access as 'users'. below is my script

SECTION ACCESS;
LOAD
Upper(ACCESS) as ACCESS,
Upper(USERID) as USERID,
Upper(Text(ID)) as ID
INLINE [
ACCESS, USERID, ID
ADMIN, INTERNAL\SA_SCHEDULER, *
ADMIN, IUSER\xxxxxxx10, *

USER, IUSER\xxxxxxx73, xxxxxxx73 -- associate

USER, IUSER\xxxxxxx73, xxxxxxx27 -- lead
USER, IUSER\xxxxxxx27, xxxxxxx27 -- lead

USER, IUSER\xxxxxxx73, xxxxxxx13 -- manager
USER, IUSER\xxxxxxx27, xxxxxxx13 -- manager
USER, IUSER\xxxxxxx13, xxxxxxx13 -- manager
];Section Application;

-- this is my source data. I need to implement section access for hierarchy based roles where associates can only see thier own data, lead can see theirs and associates similarly manager can see both associates and leads data based on ID field reduction

[Nithin29]

The same script is working fine for specific user who is also a qlik developer (holds both creator and publisher access) but not working for others who just hold only creator or viewer access) but Admin access is working for them. 'USER' access is denied when they open an application

[Daniel_Castella · Accepted solution]

Hi @Nithin29 

Maybe I'm wrong but I think you cannot write comments inside an inline table. If you do it, it is not considered as a comment, but part of the value. Also, note that in Qlik, the comments are set with //, not --.

Hence, I would try first to remove all "-- associate" and similar. If that is needed, you can always add the field Role in the Inline and not load it in the Section Access, like this:

SECTION ACCESS;
LOAD
Upper(ACCESS) as ACCESS,
Upper(USERID) as USERID,
Upper(Text(ID)) as ID
INLINE [
ACCESS, USERID, ID, Role
ADMIN, INTERNAL\SA_SCHEDULER, *
ADMIN, IUSER\xxxxxxx10, *

USER, IUSER\xxxxxxx73, xxxxxxx73, associate

USER, IUSER\xxxxxxx73, xxxxxxx27, lead
USER, IUSER\xxxxxxx27, xxxxxxx27, lead

USER, IUSER\xxxxxxx73, xxxxxxx13, manager
USER, IUSER\xxxxxxx27, xxxxxxx13, manager
USER, IUSER\xxxxxxx13, xxxxxxx13, manager
];Section Application;

Let me know if this works for you.

Kind Regards

Daniel

[Nithin29]

thank you daniel, its working now.