Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

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

by ig (Vicar)
on Aug 21, 2012 at 07:47 UTC ( #988622=note: print w/ replies, xml ) Need Help??


in reply to How to ensure that a supported version of my script is being executed?

Even if you lock down your application, if your users have permission to enter junk data in your database they can write their own application to do it, or just connect to it with Excell and Access and start entering junk.

If you want to prevent them entering junk, remove direct access to the database and only let them run stored procedures which validate the inputs.


Comment on Re: How to ensure that a supported version of my script is being executed?
Re^2: How to ensure that a supported version of my script is being executed?
by sanbiswa (Initiate) on Aug 21, 2012 at 08:45 UTC
    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.

      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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://988622]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (12)
As of 2014-08-20 09:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (110 votes), past polls