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

Darrel O'Pry dopry at thing.net
Mon Mar 13 21:51:22 UTC 2006


On Mon, 2006-03-13 at 12:10 -0500, Khalid B wrote:
> > 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.

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



More information about the development mailing list