Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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

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