Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Yes!! As you guessed..
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.
did you solve the issue?
Andrea,
I have just started working on it. I will post the comment shortly.
Thanks,
Mohan
Andrea,
Thanks for your time,
Now, user can access to the application, but without any reduction in data.
Best regards,
Mohan
And,
Along with this I changed the domain name as shown in the QMC "User Directory" under license allocation tab.
please mark the reply as Correct/Helpful to help other users with the same needs.
if you think your question has been answered click on "Correct Answer" and close the thread.
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".
that's because of data reduction.
for which users you get the message "no data to display" ?
are you using my script code ?