Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

svsudhakar
Contributor

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
neetha_p
Honored Contributor

Re: Login issue

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.

13 Replies
chiru_thota
Valued Contributor

Re: Login issue

Hi,

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

Re: Login issue

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

Peter

svsudhakar
Contributor

Re: Login issue

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

svsudhakar
Contributor

Re: Login issue

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
Valued Contributor

Re: Login issue

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
Valued Contributor

Re: Login issue

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

neetha_p
Honored Contributor

Re: Login issue

Hi Sudhakar,

Can you post sample script.

svsudhakar
Contributor

Re: Login issue

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
Valued Contributor

Re: Login issue

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

Community Browser