Discussion Board for collaboration on QlikView Security and Governance.
I am trying to implement section access based on NTName,
script as below:
LOAD * INLINE [
ACCESS, USERID, PASSWORD, NTNAME, SENTCODE
USER, AEE\JASON WHELAN, BPM
ADMIN, *, *, AEE\SUPPORT,BPM
reloaded document and set document configuration to reduce data on section access and use strict exclude.
I can still open the report in QLikview client. but when I log onto Accesspoint and try to open the report, it says "failed to open document, you don't have access to this document."
I logged onto server as AEE\support user.
any idea what I did wrong in the script?
Go to Solution.
another try, just uncheck "Strict Exlcution" in the Opening tab of the Document property and access it from Access point.
If it worked, then the issue is with Data
Is it the same application that you are able to open from QV client or copy of the application. are you sure the application is having data with value "BPM" for SENTCODE.?
Same application I can open in QV client, but can't open in accesspoint.
Yes, there is definitely have BPM for SENTCODE.
in your QMC, the security configuration is NTFS or QMC? If it is QMC then you have to assign the user name to your qvw document in the QMC.
The QMC is using NTFS authorization.
In that case, just for a try, browse your qvw file in windows explorer, right click and go to the property window and in security tab manually add the NT Name and try open it from accesspoint.
user support is added to the document security. still can't open.
Am I made mistake on NTName? NTNAME should be the domain user, isn't it?
Yes it is domain user name. Try to print OSUser name in your QV applicaiton and check whether system is capturing the NT Name as you mentioned in your inline load.
Yes.. NTNAme should be in Domain!!
Hey, I have done that too. OSUser() returns AEE\SUPPORT.