Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
PFAif u have any clarification please let me know
Is other user password entered which is correct?
Is window authentication ?
I section access table fields colums and values are Upper case.if possible post section code .
is there a restriction on field values for the Users?
Can you post the SA script here?
If You are able to login using admin access ten,
1.Take backup of your script.
2 change all your passwords.
3Reload the script
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 ....
Yes Mayil, the user password entered are correct. but the message says "Access denied to this Qlikview document'
Hey Angel and Perumal, i tried ur way of converting all fields to uppercase. It still is giving the same problem.
Can you able to provide your script ?