topic Section Access - User without Password in QlikView

Section Access - User without Password

Fri, 11 Mar 2011 14:54:44 GMT

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

Section Access - User without Password

Fri, 11 Mar 2011 15:14:42 GMT

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?

Section Access - User without Password

Anonymous — Fri, 11 Mar 2011 15:18:57 GMT

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.

AW:Re: Section Access - User without Password

Fri, 11 Mar 2011 15:54:14 GMT

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!