Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
mongolu
Creator
Creator

Document execute flag is a must ?

Hello everybody.

I upgraded QlikView Dekstop full client from 11.2SR11 to 11.2SR15 (which at this moment is the lastest SR for 11.2 version).

I have all the checks on checked state in "User preferences / Security" (see picture below).

user preferences - security.jpg

In QVW file i don't have checked "Can Execute External Programs".

reload script - security.jpg

When reloading, a warning is poped up which says "Security Alert - Unauthorized statement" regarding the EXECUTE statement in the script.

reloading - security alert.jpg

In my understanding, the checked option in "User Preferences / Security / Script (Allow Database Write and Execute Statements" must override the check in "Reload Script / Security / Can Execute External Programs".

This is not happening in this version, QV Destkop 11.2 SR 15.

I don't want to check in "Reload Script / Security / Can Execute External Programs" because I have many QVWs in which EXECUTE is used in nightly batch reloading processes.

Is there a way to make security check in User Preferences to work as is should ?

Thank you.

Labels (5)
1 Reply
rwunderlich
MVP
MVP

This seems to have changed from what I documented here.

Authorizing the Script EXECUTE Statement | Qlikview Cookbook

I tested on SR7, and the "Can Execute" checkbox was not required if Override was checked. I tested with SR13 and both properties were required.  I'm not sure at what SR it changed.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com