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