topic Re: unable to login as user after implementing section access in QlikView

unable to login as user after implementing section access

Fri, 08 Apr 2016 18:38:13 GMT

sunindia‌ @Sunny T

I have implemented section access to provide sheet level access to Users.

My excel file data

My script for section access to users

with the above code, I am able to login as USER A but not as other user(B,C, D)

I am getting the errors as "Access denied to this document".

can anyone please help me with this.

Thanks in Advacne

Re: unable to login as user after implementing section access

satishkurra — Fri, 08 Apr 2016 19:16:55 GMT

It is not even allowing to me login with Admin as well

Re: unable to login as user after implementing section access

sunny_talwar — Fri, 08 Apr 2016 19:17:30 GMT

I am going to check once the app downloads

Re: unable to login as user after implementing section access

Fri, 08 Apr 2016 19:25:51 GMT

I dont know, but i am able to login with A...

Re: unable to login as user after implementing section access

sunny_talwar — Fri, 08 Apr 2016 19:30:44 GMT

Admin is working, User isn't working. Not sure what might the issue be

Re: unable to login as user after implementing section access

Fri, 08 Apr 2016 19:33:57 GMT

actually there is a hidden script when u r able to login as A.. its password is 'mile' can you try by removing it.. is that causing some issue..

Re: unable to login as user after implementing section access

sunny_talwar — Fri, 08 Apr 2016 19:35:26 GMT

Even if I remove the stuff in the hidden script, there is no way I can refresh the application.

Re: unable to login as user after implementing section access

Fri, 08 Apr 2016 19:42:58 GMT

Yeah its not getting reloaded for me as well...

Re: unable to login as user after implementing section access

sunny_talwar — Fri, 08 Apr 2016 19:43:51 GMT

Isn't this your own application?

Re: unable to login as user after implementing section access

Fri, 08 Apr 2016 19:45:10 GMT

yes its mine

Re: unable to login as user after implementing section access

sunny_talwar — Fri, 08 Apr 2016 19:46:47 GMT

Then why are you not able to reload it?

Re: unable to login as user after implementing section access

Fri, 08 Apr 2016 19:54:32 GMT

dont know, even i commented the odbc connection

Re: unable to login as user after implementing section access

sunny_talwar — Fri, 08 Apr 2016 19:58:08 GMT

What is the error you are getting?

Re: unable to login as user after implementing section access

Fri, 08 Apr 2016 20:39:02 GMT

sorry, for the late reply sir.

my system got hanged after few reloads of the document..

actually, qvw file is not getting reloaded, i am not getting any error for it,

but when i tried to login as user i am getting the error as

"Access to the document is denied"..

Re: unable to login as user after implementing section access

Mon, 11 Apr 2016 05:09:57 GMT

you may want to add 'reduction' line and add the server where your users are accessing their data

Section Access;

LOAD * inline

[ACCESS,USERID,REDUCTION

USER,server\A,*

USER,server\B,1

USER,server\C,2

USER,server\D,3

USER,server\E,3

USER,server\F,4

];

Section Application;

* = all data are accessible

1-4 - sectional access

Re: unable to login as user after implementing section access

Chanty4u — Mon, 11 Apr 2016 06:16:34 GMT

hi,Denied access to this document

Re: unable to login as user after implementing section access

Peter_Cammaert — Mon, 11 Apr 2016 07:02:49 GMT

What is the password for the hidden script?

AFAIK you did something weird: your hidden script is still present, but there is also a regular script tab with a copy of the hidden script code. We can't test anything if we're not able to edit the hidden script, which apparently produces errors...

Re: unable to login as user after implementing section access

Mon, 11 Apr 2016 07:21:17 GMT

Check the attached qvw.

Re: unable to login as user after implementing section access

Mon, 11 Apr 2016 07:46:11 GMT

sorry. i forgot to remove it before uploading on the community.. password is 'mile'

Re: unable to login as user after implementing section access

Peter_Cammaert — Mon, 11 Apr 2016 08:18:17 GMT

There isn't anything wrong about your document that I can find. However, it causes a lot of trouble when I try to start a reload. The solution to this is to open your document without data (open QV Desktop, right click the document entry in the Recent documents overview and select "Open 'Section Access' without data") then log in as user 'A', reload and save.

See if that helps you out.

Best,

Peter

PS To get as far as this, I did remove the hidden script as your Section Access code appears in the regular script already.