topic Re: Please enter your User ID while using NTNAME in the Section Access in QlikView

Please enter your User ID while using NTNAME in the Section Access

arnoqlik — Sat, 16 Nov 2024 17:48:28 GMT

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!

Re: Please enter your User ID while using NTNAME in the Section Access

Chanty4u — Thu, 19 Nov 2020 09:39:58 GMT

Hi Can you try this

LOAD ACCESS, UPPER(NTNAME) as NTNAME, %AUTHID

inline[

ACCESS, NTNAME, %AUTHID
ADMIN, qlik_admin, '*'
];

Section Application;

Re: Please enter your User ID while using NTNAME in the Section Access

arnoqlik — Thu, 19 Nov 2020 09:47:32 GMT

Thanks but it doesn't help.

Re: Please enter your User ID while using NTNAME in the Section Access

Chanty4u — Thu, 19 Nov 2020 09:52:27 GMT

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.

Re: Please enter your User ID while using NTNAME in the Section Access

arnoqlik — Thu, 19 Nov 2020 10:05:58 GMT

The option was already enabled in the document properties.

I still have the popup.

Re: Please enter your User ID while using NTNAME in the Section Access

Chanty4u — Thu, 19 Nov 2020 10:16:08 GMT

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;

Re: Please enter your User ID while using NTNAME in the Section Access

arnoqlik — Thu, 19 Nov 2020 10:29:55 GMT

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?

Re: Please enter your User ID while using NTNAME in the Section Access

Chanty4u — Thu, 19 Nov 2020 10:34:14 GMT

Yes, have a look here once.

https://community.qlik.com/t5/New-to-QlikView/How-to-avoid-the-prompt-for-USER-ID-with-section-access-on/td-p/7609

Re: Please enter your User ID while using NTNAME in the Section Access

arnoqlik — Thu, 19 Nov 2020 15:14:41 GMT

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...