Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

Re: How I can prohibit insert and update in Script in Qlikview

Unfortunately no ...

3 Replies
alexandros17
Not applicable

Re: How I can prohibit insert and update in Script in Qlikview

Unfortunately no ...

Gysbert_Wassenaar
Not applicable

Re: How I can prohibit insert and update in Script in Qlikview

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
Not applicable

Re: How I can prohibit insert and update in Script in Qlikview

"Unfortunately no ..."?!

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

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