topic Re: Prompting for password in QlikView

Prompting for password

LoveQ — Fri, 15 Nov 2024 21:52:08 GMT

I have macro set up in my qlik document. Every time I try to run that macro it is asking me for password. There is no password set up in the macro by my coworker but for some strange reason Qlik is asking password. How do I overcome this issue.

Re: Prompting for password

Frank_S — Thu, 12 Jan 2023 19:19:25 GMT

What Kind of Qlik Document is it QVF or QVW?

Re: Prompting for password

LoveQ — Thu, 12 Jan 2023 19:21:35 GMT

It is QVW.

Re: Prompting for password

Frank_S — Thu, 12 Jan 2023 19:39:02 GMT

Then if you are getting prompted for a password, then you likely have QlikView Section Access in the load script.

If you are the developer you need to check load script.

If you are not the developer of the QVW, you need to speak to that person and either:

You can either

--remove section access from the load script

--update your load script to use NTFS authorization, using the following:
https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/manage-security-with-section-access.htm

Kind regards...

Re: Prompting for password

LoveQ — Thu, 12 Jan 2023 22:14:56 GMT

I wrote the sql script myself for this QVW and there is no QlikView Section Access part in the sql. It is a basic sql script with joins and filters. And nowhere in the script it has password code or hidden script. I don't know why it is prompting me for macro password.

Thank you.

Re: Prompting for password

Frank_S — Thu, 12 Jan 2023 22:29:50 GMT

Ok check that this 'override macro security' is enabled in the 'document properties'

If that still doesn't work. do this...Select to override security..

But use these with care and discretion.

Finally if you inherited the app from another person, then you might have hidden script.

This is mentioned here:
https://community.qlik.com/t5/QlikView-App-Dev/Module-password/td-p/268329

Kind regards...

Re: Prompting for password

Frank_S — Thu, 12 Jan 2023 22:35:55 GMT

In the meantime, I will move this to the QlikView community to get more eyes on this.

https://community.qlik.com/t5/QlikView-App-Dev/bd-p/qlikview-app-development

cheers!

Re: Prompting for password

marcus_sommer — Fri, 13 Jan 2023 10:47:32 GMT

What does the macro do? Maybe the password-query comes from the called action.

Re: Prompting for password

Bill_Britt — Fri, 13 Jan 2023 12:12:53 GMT

Could the password be coming from SQL?

Re: Prompting for password

LoveQ — Tue, 17 Jan 2023 22:04:39 GMT

I don't know what the macro does. It is not my macro. My coworker is using it to do some data analysis.

Re: Prompting for password

LoveQ — Tue, 17 Jan 2023 22:05:35 GMT

No, I created the sql script so I know there is no password there.

Re: Prompting for password

marcus_sommer — Wed, 18 Jan 2023 08:43:44 GMT

Then take a look in the macro. Usually it's not difficult to find the part which caused the password-query - probably any access to a database, website, storage/network or similar. If it's really not obvious you may integrate some extra msgbox to see which ones come before the password. Maybe it's just an internal measurement to prevent that the macro is accidentally executed.