I am using NTFS authorization, but have tried both DMS and NTFS, with the same result.
NTFS rights are set individually on the folders and files.
The problems occur only with local users, created on the QlikView server. We are using local users for the external clients.
Domain users can access the QlikView files without any problems.
This is what I have in Section Access:
Upper(SERIAL) as SERIAL,
Upper(ACCESS) as ACCESS,
Upper(NTNAME) as NTNAME,
//Upper(PASSWORD) as PASSWORD,
Upper(COMPANY) as COMPANY,
Upper(SHEET) as SHEET
FROM "security.xls" (biff, embedded labels, table is [Security$])
WHERE COMPANY = '$(BusinessUnitLimit)' OR Upper(COMPANY) = 'ALL';
Upper(ORDERTYPELIMIT) as ORDERTYPELIMIT
FROM "security.xls" (biff, embedded labels, table is [Order Type Limit$])
WHERE EXISTS([Order Type]);
SHEET as Sheet
FROM "security.xls" (biff, embedded labels, table is [Security$]);
This is our security.xls (slightly altered for confidentiality purposes):
The local users are defined in the security.xls spreadsheet. The example in the screen dump above is 'smarttest', a local user who has rights to the test files.
I have tried using the following simple section access and this works after a data reload.
LOAD * INLINE [
ACCESS, USERID, PASSWORD
USER, ABC, ABC
ADMIN, ADMIN, ADMIN
That leaves the security.xls. Something is obviously wrong with this file or the data format in some of the columns.
We have used the same format in QlikView 8 for several years, so I am a bit surprised that it's giving us problems at this point. The format of the spreadsheet has not changed.
Yep, that's what I suspected. Take a look at my wiki article here: http://community.qlik.com/wikis/qlikview-wiki/iphone-clients-amp-section-access.aspx. It was originally written for IPhone clients, but I think you may find it helpful to your situation as well.
I found the solution. It's almost embarrassing how simple, but maybe their are other users who would benefit from our ignorance.
- If you are using section access, you need to reload the QlikView document every time we create a new user.
- As long as you don't reload the QlikView document, the user will be presented with a second log-in prompt.
Thanks to Vlad for his assistance and prompt responses.