Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Unfortunately no ...

View solution in original post

3 Replies
Highlighted

Unfortunately no ...

View solution in original post

Highlighted
MVP & Luminary
MVP & Luminary

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
Highlighted
Partner
Partner

"Unfortunately no ..."?!

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

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