13 Mar
2006
13 Mar
'06
10:51 p.m.
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