I'd check that the Strict Exclusion is checked on your Document Properties, in the Settings menu.
If you use a NTNAME field in section access, it shouldn't ask for password as QlikView compares the login credentials with the Active Directory. It may ask if the user is not listed in the section access or it doesn't have a valid or corresponding NTNAME field.
I'd add a new file for each of the users is going to access the file, leaving the STATUS field empty for those users will full access, or insert all possible STATUS values in dummy lines not corresponding to any NTNAME, and using an "*" in STATUS for full access (remember that "*" in Section Access doesn't mean "all possible values" but "all listed values" for the field in the section access table).
Hope that helps.
Leaving the reduction field blank should work for admins (allowed to modify the script when the document is opened in Desktop).
Section Access controls who has access to a given document, and within it, which information is available. Any user not listed in any way (using "*" for example, is valid) won't be granted access. Using
STAR IS *; SECTION ACCESS; LOAD * INLINE [ACCESS, USERID, PASSWORD, F1ADMIN, ADMIN, ADMINUSER, -, -, A2USER, -, -, A3USER, *, *, *USER, USER1, USER1, A1]; SECTION APPLICATION; Table:LOAD * INLINE [F1, F2A1, B1A2, B2A3, B3];
Will grant all users access to A1, A2 and A3 (full access), and it won't even ask for password, while
LOAD * INLINE [ACCESS, USERID, PASSWORD, F1ADMIN, ADMIN, ADMINUSER, -, -, A2USER, -, -, A3USER, USER2, USER2, *USER, USER1, USER1, A1];
Will ask for password, but grant USER2 full access..
I'm using USERID and PASSWORD for testing purposes, changing it to NTNAME will only skip the password asking, but the results will be the same.
in some way or another, all users must be listed.
Hope that helps
Did you solve it?
Me too is getting users prompted for userid/pwd when accessing via web-client using QV9 publisher/server.
By the way, by adding your users that shall have full access to the document into a group you can save some text-rows in your script by just having to list the group and not every domain\user in the section access part.
I read some other threads about this and the thing is that when you access via Accesspoint you always become a USER (even if listed as a ADMIN in the section access part). If you leave the reduction field blank there will be nothing for Qlikview to reduce on and you are prompted for the userid/pwd. Filling in the reduction field will solve it as mentioned by previous posters.