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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How I can prohibit insert and update in Script in Qlikview

I would like prohibit that developers can use commands insert and update in SQL Script during reload from aplication in the qlikview.

I get it, trough ODBC, but i'd like to know if Qlikview have something native for treat this question.

Thank,

Gilvan

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

Unfortunately no ...

View solution in original post

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Unfortunately no ...

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

In Qlikview a developer has to specifically enable Write mode. But if the developer has full access to the script editor in Qlikview then he/she can enable that option. If you want to disallow writing to the database you will have to restrict those privileges at the database level. This means create a database user login with only the privileges to read data and give only the credentials for this read-only user to the Qlikview developer.


talk is cheap, supply exceeds demand
stantrolav
Partner - Creator II
Partner - Creator II

"Unfortunately no ..."?!

I can say YES you can do it! Look through this example:

http://community.qlik.com/docs/DOC-6386