Re: [development] Can someone confirm -- Minimum MySQL Privileges?

Khalid, In a mysql context, LOCK TABLE is an admin privilege... W

That is the way it should be. But for Drupal on MySQL (by far the most common configuration out there), LOCK TABLE is needed by the user to do normal things. We thought about separating privileges by "user" and "admin" where "admin" would be the one needing to upgrade the database (i.e. CREATE, ALTER, ...etc.) Even in this case, we would still need LOCK TABLE for the normal "user", until we found a satisfactory way to do auto increment AND get the last added ID. My recollection is that we are OK unless we are using persistent connections ...