On 6/7/2012 7:42 PM, Bob Hoffman wrote:
*On a final note....*
If you are building a web application you should use a mysql user that is only allowed to update and select... With proper programming you can set up items to be deleted via a cron job using a mysql user that has a bit more access.
This prevents a hacker from actually deleting or altering any data....and easily rolled back.
This is how I program and I think it should be standard. As far as I know not one single program does this...and that is a shame.
Sorry, I meant select and insert only.