[development] Can someone confirm -- Minimum MySQL Privileges?
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.
In a mysql context, LOCK TABLE is an admin privilege... W
More information about the development