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: 
svsudhakar
Creator
Creator

Login issue

Hi ,

I have developed one dashboard with Section access. Am able to access the application with my id in server, once published the same app I am getting don't have permission error.

I have an  license and  configured my id in the section script also.

Kindly help on this issue.

thanks in Advance,

Regards,

sudhakar

13 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Also, the 'ALL' value in your three section access fields doesn't link to anything because it is a distinct but meaningless value to QlikView. Replace it with a *, and put the following statement before your section access LOAD statement:

STAR IS *;

Keep in mind also that if you are defined as ADMIN in section access, you will always be able to open a QVW document in desktop because the data reduction rules are partially switched off. In the AccessPoint however, this nice trick won't work and you will be treated as any other USER.

Best,

Peter

Anonymous
Not applicable

HI Sudhakar,

Replace All with * and use STAR IS *;

As per my knowledge even * includes only values in Section access code and there are no values other then *  in access section.

For Ex:

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REGION

ADMIN, ADMIN, ADMIN,

USER, USER1, U1, AFRICA

USER, USER2, U2, AMERICA

USER, USER3, U3, ASIA

USER, USER4, U4, EUROPE

USER, USER5, U4, AMERICA

USER, USER5, U5, *

];

Section Application;

SALES:

LOAD * INLINE [

REGION, PROFIT

AFRICA, 1000

AMERICA, 2000

ASIA, 3000

EUROPE, 4000

OCEANIA, 5000

];

USER5 will be able to see all regions listed in the reduction field REGION except for

  1. OCEANIA.

Even if USER5 has “*“ for the REGION reduction field, star means “all listed values”

not all values for the field. Since no USER has OCEANIA listed for the REGION field,

USER5 will not have access to the values for OCEANIA.

If we want USER5 to see OCEANIA as well, we need to add an extra line in our section

access solution

USER, USER5, U5, OCEANIA

Hope this helps.

svsudhakar
Creator
Creator
Author

I have removed the %columns from Section Access and replaced the All with *.

now its working fine.

thank you

svsudhakar
Creator
Creator
Author

I have removed the %columns from Section Access and replaced the All with *.

now its working fine.

thank you