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

1 Solution

Accepted Solutions
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.

View solution in original post

13 Replies
chiru_thota
Specialist
Specialist

Hi,

Are you able to access the same application from access point if you remove section access code ?

Peter_Cammaert
Partner - Champion III
Partner - Champion III

You must be using the NTNAME field in your section access table. Did you enter your credentials as domainname\username ?

Peter

svsudhakar
Creator
Creator
Author

yes..am able to access the same application with out section access..

svsudhakar
Creator
Creator
Author

i have used the NTNAme filed in my script. i have given access to particular users based on their Ad Id's

like Domain name\ADID.... but i didn't given the password's.

chiru_thota
Specialist
Specialist

I guess paswword is not required if we use windows authentication.

Some thing must be wrong with your code or QEMC settings.(Ex: All authenticated etc)

Some times  order of the tab (with script code ) also create problems.I had this issue.

Can you post your sample code here ?

gainkarthi
Partner - Specialist
Partner - Specialist

Sudhakar,

Give admin rights to the service account (Qlikview service account) in your section access table. Run the task and see if your access is permitted.

Regards,

Karthi

Anonymous
Not applicable

Hi Sudhakar,

Can you post sample script.

svsudhakar
Creator
Creator
Author

Please find the below sample script. which I have implemented

Section Access;
LOAD * INLINE [

    ACCESS, NTNAME, %SBU, %LOB, %REGION
    ADMIN, Domain\zzzz,ALL,ALL,ALL
    ADMIN, Domain\yyyy,ALL,ALL,ALL
    ADMIN,Domain\XXXX,ALL,ALL,ALL
]
;
Section Application;

LOAD * INLINE [
    SBU, %SBU
    AA, ALL_AA
    Others, ALL_OTHERS
    GM, ALL_GM
    Go., ALL_GO
    HL, ALL_HL
    EN, ALL_EN
]
;
LOAD * INLINE [

    LOB, %LOB

    A, ALL_A

    B, ALL_B

    C, ALL_C

    D, ALL_D

    E, ALL_E

    F, ALL_F



]
;


LOAD * INLINE [

    Region, %REGION

    West, ALL_WEST

    South1, ALL_SOUTH1

    Gulf, ALL_GULF

]
;


chiru_thota
Specialist
Specialist

remove % from section access columns.it did not work for me in our application