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

Khalid B kb at 2bits.com
Mon Mar 13 17:10:10 UTC 2006


> Khalid B wrote:
> > In includes/database.mysql.inc there is this pesky function called
> > db_next_id() that users need ...
> >
> > It has:
> > LOCK TABLES sequences WRITE
> > and
> > REPLACE INTO sequences ...
> >
> > This is needed for normal operation (creating nodes, users registering, ...etc.)
>
> Yeah, I couldn't find reference to a specific permission for "REPLACE" --
> according to http://dev.mysql.com/doc/refman/5.1/en/replace.html it seems to
> take its permissions from a combination of INSERT and DELETE. "LOCK TABLES" is
> already added to the list, so I think we're good there.

No. You missed the point.

Normal users *need* LOCK TABLE privilege, not just admins.


More information about the development mailing list