Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
umartareen
Contributor

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

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 ?

perumal_41
Valued Contributor II

Re: Section Access

Hi Umar,

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

Regards,

Perumal A

martinpohl
Valued Contributor II

Re: Section Access

Hi,

is there a restriction on field values for the Users?

Can you post the SA script here?

Regards

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

Re: Section Access

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

umartareen
Contributor

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

Re: Section Access

!

Community Browser