Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Unfortunately no ...
Unfortunately no ...
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.
"Unfortunately no ..."?!
I can say YES you can do it! Look through this example: