Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
umartareen
Creator II
Creator II

Section Access

Hi,

When I am applying section access, only the UserId of Admin is able to login, but when i try to log in from the other users, it says access denied. Can you help me out with this.

Thank You.

Regards

Umar

1 Solution

Accepted Solutions
perumal_41
Partner - Specialist II
Partner - Specialist II

Hi Umar,

PFA
if u have any clarification please let me know

Regards,

Perumal A

View solution in original post

23 Replies
MayilVahanan

Hi

Is other user password entered which is correct?

or

Is window authentication ?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
perumal_41
Partner - Specialist II
Partner - Specialist II

Hi Umar,

I section access table fields colums and values are Upper case.if possible post section code .

Regards,

Perumal A

martinpohl
Partner - Master
Partner - Master

Hi,

is there a restriction on field values for the Users?

Can you post the SA script here?

Regards

deepakqlikview_123
Specialist
Specialist

Hi Umar,

If You are able to login using admin access ten,

1.Take backup of your script.

2 change all your passwords.

3Reload the script

Thanks

Not applicable

Can you post your Section Access Script?

make sure you have used Uppercase in your fields, otherwise it may not work properly. Something like:

LOAD
 
ACCESS,
 
UPPER(USERNAME) AS USERID,
 
UPPER(PASSWORD) AS PASSWORD,
    
UPPER(ACCESSTO) AS ACCESSTO
FROM ....

I

Greetings,

Angel

umartareen
Creator II
Creator II
Author

Yes Mayil, the user password entered are correct. but the message says "Access denied to this Qlikview document'

umartareen
Creator II
Creator II
Author

Hey Angel and Perumal, i tried ur way of converting all fields to uppercase. It still is giving the same problem.

MayilVahanan

Hi

Can you able to provide your script ?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
umartareen
Creator II
Creator II
Author

!