Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Access - User without Password

Hi,

I've got a problem by logging in a Default User without a password. Actually I've got two problems.

1. Default User without password

My section access got 3 types of Users. First an Admin, secondly a User (both with a given password) and last but not least a User without a password. The way Users logging in, I want to display a certain sheet or not. The defined password for the Admin and User (No. 1) works properly. For User No. 2 (the one without a password) I defined the password with '*' (asterix), because I don't want to assign one. Every time I opened the file no prompt is shown. If I use space between the inverted commas, the prompt is on screen, but to pass it's necessary to type in a space. What I want is a prompt where the Admin or User (No. 1) can type in their password OR (User No. 2) quit the prompt by press "OK" without typing in anything. Does anybody got an idea?

This is my code:

// Section Access
Star is *;

Section Access;
Load * INLINE [PASSWORD, ACCESS, SHEET_ID
1111, ADMIN
4321, User, X
' ', User, Y
]
;


2. Asking for USERID even there is no USERID set

Same case as above. In the section access I defined no USERID. To separate, I just want to ask for password. If I open the map via filesystem (with fat client), QV just asking for password. If I open via QV Server (like the Analyzers do) it is asking for UserID and password although there is no USERID. How can I prohibit the USERID prompt?

Thank you for help.

Greets
Ingo

Client Build Number 10.00.8715.0409 / Server 9.0.7469.8

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

For the first problem it does work fine with a simple load like that

load * inline [

ACCESS, USERID, PASSWORD

ADMIN, ADMIN, ADMIN

USER, USER1, U1

USER, USER2

];

But using a USERID field. I don't think that skipping this field is a good idea, I have tested it on my desktop client and it does not work, does it really at your side?

View solution in original post

3 Replies
Not applicable
Author

Hi,

For the first problem it does work fine with a simple load like that

load * inline [

ACCESS, USERID, PASSWORD

ADMIN, ADMIN, ADMIN

USER, USER1, U1

USER, USER2

];

But using a USERID field. I don't think that skipping this field is a good idea, I have tested it on my desktop client and it does not work, does it really at your side?

Anonymous
Not applicable
Author

Ingo,
As far as I know, Section Access should always have a field that identifies current user one way or the other. By user login (USERID), by machine, machine & domain. Field PASSWORD does not identify user, you can skip it.
So, I'd recommend you to use USERID, ACCESS, and SHEET_ID in your Section Access. And, no blank user.

Not applicable
Author

Thank you for your reply. I think I'll do it like this.

Curiously there's no need to type in USERID so far, when opening with QV client from file system directly. If you can't simulate I'll better take my hands of ... Thanks!