Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

udaya_kumar
Valued Contributor

Access Denied to this QlikView Document

Hi,

I have applied section access to my qlikview document.

i have applied row level security.

i have one list box by name 'flag', and i have created inline userid and password.

below is the section access script which i have used

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    Admin, abroker, abroker

    User, acost, acost

    User, breed, breed

    User, brotter, brotter

    User, sallsop,sallsop

    User, samo, samo

];

Section Application;

LOAD * Inline [

USERID, flag

acost, 1

breed, 2

brotter, 3

sallsop, 0

samo, 12

];

when i save and open the document by using some user credentials like acost and acost, then am getting this error 'Access Denied to this QlikView Document'.

i dont know why am getting this error. i saw some video about security in qlikview community and implemented same, but also am getting this error.

am using qlikview 11.

can anyone help me out in this issue?

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Access Denied to this QlikView Document

It should be like this...

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN, ABROKER, ABROKER

    USER, ACOST, ACOST

ETC.......

];

Section Application;

Good luck.

9 Replies
Not applicable

Access Denied to this QlikView Document

Try changing the syntax so it is all in upper case in the section access area..

This may help

udaya_kumar
Valued Contributor

Access Denied to this QlikView Document

Hi,

Thanks for reply,

which one you want me to change the syntax?

which one i need to change it in Upper case?

Not applicable

Access Denied to this QlikView Document

It should be like this...

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN, ABROKER, ABROKER

    USER, ACOST, ACOST

ETC.......

];

Section Application;

Good luck.

udaya_kumar
Valued Contributor

Access Denied to this QlikView Document

hi,

But i have Userid's getting from Database field, those names are in lower case.

so will it affect these uppercase names?

Not applicable

Access Denied to this QlikView Document

I don't believe so, from memory I don't think mine was affected by the difference in syntax.... however make sure you back up before testing it..

Not applicable

Access Denied to this QlikView Document

If there is an issue with it just place the upper formula before the load when you bring in the application table.

udaya_kumar
Valued Contributor

Access Denied to this QlikView Document

Hi,

thanks for the help, its working fine after changing everything to uppercase.

Not applicable

Access Denied to this QlikView Document

I'm glad it helped

its a shame you had to change everything though...

udaya_kumar
Valued Contributor

Access Denied to this QlikView Document

No Prob

but thanks for the great help

Community Browser