Re^2: How to ensure that a supported version of my script is being executed?

[sanbiswa]

Thanks for your response. I do have all the mechanisms in place (stored procedures with proper grants etc.) so that the users can modify the database only via this script. So his modified script gets into the database and writes x instead of y; how to prevent that? Validating the data entered is not always possible in my case, so my idea was to ensure that the script that entered such data is the correct one.

[ig]

How do you prevent the user entering x instead of y in your script?

If your script doesn't allow the user to enter x or y, but derives y from some other input, then don't accept either x or y as input to your stored procedure but, rather, accept only the primary input from which y can be derived.