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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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
Partner Ambassador/MVP
Partner Ambassador/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