Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mohan_1105
Partner - Creator III
Partner - Creator III

Session Access Not working for user

Hello Qlikers,

I have written the section access in my application, while the user tries to log in they are getting message "Access Denied".

I restricted my login(administrator) in section access and validate it in the application. Section access is successfully applied in my login. For other users, they are getting "Access Denied" message.


Also, I'm using the Binary function in my script. The section access is defined after the binary load.

Kindly provide solution...!!

Regards,

Mohan

23 Replies
mohan_1105
Partner - Creator III
Partner - Creator III
Author

Yes!! As you guessed..

agigliotti
Partner - Champion
Partner - Champion

no you could use section access in both apps.

anyway i think you should do something like below:

-----

section access;

Tab_users:

LOAD * inline [

ACCESS,USERID,SA_SECTION

USER,MDSTIQLIK\ADMINISTRATOR,ALLVALUES

USER,MDSTIQLIK\ADMINISTRATOR,ASM_C1MV_ZSM_WEST

USER,MDSTIQLIK\ADMINISTRATOR,ASM_C2OC_ZSM_EAST

USER,MDSTIQLIK\ADMINISTRATOR,ASM_E1NE_ZSM_EAST

USER,MDSTIQLIK\ADMINISTRATOR,ASM_E1WB_ZSM_EAST

USER,MDSTIQLIK\ADMINISTRATOR,ASM_E2BR_ZSM_EAST

USER,MDSTIQLIK\ADMINISTRATOR,ASM_N1NR_ZSM_N1N2

USER,MDSTIQLIK\ADMINISTRATOR,ASM_N2NR_ZSM_N1N2

USER,MDSTIQLIK\ADMINISTRATOR,ASM_N3NR_ZSM_N1N2

USER,MDSTIQLIK\ADMINISTRATOR,ASM_N4RJ_ZSM_N1N2

USER,MDSTIQLIK\ADMINISTRATOR,ASM_S1TN_ZSM_S1S2

USER,MDSTIQLIK\ADMINISTRATOR,ASM_S2KA_ZSM_S1S2

USER,MDSTIQLIK\ADMINISTRATOR,ASM_S2KL_ZSM_S1S2

USER,MDSTIQLIK\ADMINISTRATOR,ASM_S3AP_ZSM_S1S2

USER,MDSTIQLIK\ADMINISTRATOR,ASM_WEGJ_ZSM_WEST

USER,MDSTIQLIK\ADMINISTRATOR,ASM_WEMH_ZSM_WEST

USER,MDSTIQLIK\PRASADV,ASM_C2OC_ZSM_EAST

USER,MDSTIQLIK\PRASADV,ASM_E1NE_ZSM_EAST

USER,MDSTIQLIK\PRASADV,ASM_E1WB_ZSM_EAST

USER,MDSTIQLIK\PRASADV,ASM_E2BR_ZSM_EAST

USER,INTERNAL\SA_SCHEDULER,ALLVALUES

USER,MDSTIQLIK\KKATHIRAVAN,ASM_C2OC_ZSM_EAST

USER,MDSTIQLIK\KKATHIRAVAN,ASM_E1NE_ZSM_EAST

];

section application;

star is '*';

ReductionTable:

LOAD Distinct

SA_SECTION,

SA_SECTION as SECTION

Resident Tab_users Where SA_SECTION <> 'ALLVALUES';

Concatenate

Load

'ALLVALUES' as SA_SECTION,

'*' as SECTION

Autogenerate 1;

-----

in your data model use SECTION as field name for data reduction.

please keep in mind that if a user can see no data caused by your data reduction that user will get "Access Denied" message opening the app.

agigliotti
Partner - Champion
Partner - Champion

did you solve the issue?

mohan_1105
Partner - Creator III
Partner - Creator III
Author

Andrea,

I have just started working on it. I will post the comment shortly.

Thanks,

Mohan

mohan_1105
Partner - Creator III
Partner - Creator III
Author

Andrea,

Thanks for your time,

Now, user can access to the application, but without any reduction in data.

Best regards,

Mohan

mohan_1105
Partner - Creator III
Partner - Creator III
Author

And,

Along with this I changed the domain name as shown in the QMC "User Directory" under license allocation tab.

agigliotti
Partner - Champion
Partner - Champion

please mark the reply as Correct/Helpful to help other users with the same needs.

agigliotti
Partner - Champion
Partner - Champion

if you think your question has been answered click on "Correct Answer" and close the thread.

mohan_1105
Partner - Creator III
Partner - Creator III
Author

Andrea,

I'd be very happy to close the thread and make it useful to other Qlicker's.

The issue is still not solved yet..!! 😞

The problem is domain name, I sync the user's directory from another server. After changing the domain name, the user can able to access the application. But the charts aren't complete, saying "charts has no data to display".

agigliotti
Partner - Champion
Partner - Champion

that's because of data reduction.

for which users you get the message "no data to display" ?

are you using my script code ?