Access Denied to this QlikView Document

[udaya_kumar]

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?

[#2]

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

This may help

[udaya_kumar]

Hi,

Thanks for reply,

which one you want me to change the syntax?

which one i need to change it in Upper case?

[#4 · Accepted solution]

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]

hi,

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

so will it affect these uppercase names?

[#6]

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

[#7]

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

[udaya_kumar]

Hi,

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

[#9]

I'm glad it helped

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

[udaya_kumar]

No Prob

but thanks for the great help