unable to login as user after implementing section access

[#1]

Hi

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

[sunny_talwar]

Then why are you not able to reload it?

[#3]

dont know, even i commented the odbc connection

[sunny_talwar]

What is the error you are getting?

[#5]

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

[#6]

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

[Chanty4u]

hi,Denied access to this document

[Peter_Cammaert]

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

[#9]

Check the attached qvw.

[#10]

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

[Peter_Cammaert]

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.