This question already has an answer here:
While installing WP, I created a mysql user to access only the relevant WP database. It's likely that not technical people will end up with access to this account, so I decided to remove DELETE and DROP privileges from this user.
Was this a bad idea? Will anything in WP not function correctly because of this.
Thus far, I got a couple of error messages during the install, but I looked up what they were doing, and that was precisely nothing. The DROP queries didn't match anything they would have dropped.
UPDATE: It seems that my question is addressed by answers in this question: MySQL Database User: Which Privileges are needed?