Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I read several threads about section access but none helped me.
I'm connected on the Qlikview server with an Admin account. I'm part of qlik_admin user group in the Active Directory.
The application I'm working on loads a security.qvs script to set the different levels of authorizations. As for the Admin acccess, here is the code:
SECTION Access;
AuthorizationTable:
// user who needs to have admin access
LOAD * INLINE [
ACCESS, NTNAME, %AUTHID
ADMIN, qlik_admin, '*'
];
As soon as I save this code and reload the application I get this message:
The only solution I found to be able to reopen the application is to open it from the desktop version of Qlikview 12 on my laptop (instead of the server), comment the loading of security.qvs and run the application from the QMC...
I already discussed with the Admin of the Qlikview server and my access seem to be OK in AD.
What else could explain my issue?
Thank you very much!
Hi Can you try this
LOAD ACCESS, UPPER(NTNAME) as NTNAME, %AUTHID
inline[
ACCESS, NTNAME, %AUTHID
ADMIN, qlik_admin, '*'
];
Section Application;
Thanks but it doesn't help.
try same script by removing single quotes in star
LOAD ACCESS, UPPER(NTNAME) as NTNAME, %AUTHID
inline[
ACCESS, NTNAME, %AUTHID
ADMIN, qlik_admin, *
];
Section Application;
Do this also:
Under Settings - Document Settings - Opening:
Check the checkbox named : Initial data reduction based on Section Access
Reload the document, save and close the instance completely and reopen.
The option was already enabled in the document properties.
I still have the popup.
is ur Admin is correct name? like it should come with "domain\Name " give a try
LOAD ACCESS, UPPER(NTNAME) as NTNAME, %AUTHID
inline[
ACCESS, NTNAME, %AUTHID
ADMIN, Domain\qlik_admin, *
];
Section Application;
Do you mean "Domain" as the name of the server on which I'm connected to?
Actually the person in charge the application before me didn't have any issue (with the same security script). Is there another setting within QMC or the document properties of the application where we could define authorizations?
Yes, have a look here once.
Sorry but I don't see how it can help me.
I tried this code:
SECTION Access;
AuthorizationTable:
// user who needs to have admin access
LOAD * INLINE [
ACCESS, NTNAME, %AUTHID
ADMIN, qlik_admin, '*'
ADMIN, <my_admin_account>, '*'
];
I can open the document now but I have no access to the data...