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

Karthik narakasura at gmail.com
Mon Mar 13 14:00:21 UTC 2006


> Data
> ====
> SELECT
> INSERT
> UPDATE
> DELETE
>
> Structure
> =========
> CREATE
> ALTER
> INDEX
> DROP
> CREATE TEMPORARY
>
> Admin
> =====
> LOCK TABLES

Considering the .install files that have been introduced, won't this
table just be "User" and "Admin"?

LOCK TABLES are used in db_next_id - i.e. in most INSERTs, thus
becoming a user privilege. Similarly, I believe CREATE TEMPORARY will
be used everytime (?) in the search module, again a user privilege.

Cheers
-K


More information about the development mailing list