Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
umartareen
Contributor 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
Partner
Partner

Re: Section Access

Hi Umar,

PFA
if u have any clarification please let me know

Regards,

Perumal A

23 Replies

Re: Section Access

Hi

Is other user password entered which is correct?

or

Is window authentication ?

Partner
Partner

Re: Section Access

Hi Umar,

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

Regards,

Perumal A

Partner
Partner

Re: Section Access

Hi,

is there a restriction on field values for the Users?

Can you post the SA script here?

Regards

Highlighted
deepaktibhe
Valued Contributor

Re: Section Access

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

Re: Section Access

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
Contributor II

Re: Section Access

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

umartareen
Contributor II

Re: Section Access

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

Re: Section Access

Hi

Can you able to provide your script ?

umartareen
Contributor II

Re: Section Access

!