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

Khalid B kb at 2bits.com
Mon Mar 13 16:47:01 UTC 2006


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.)

On 3/13/06, Angie Byron <drupal-devel at webchick.net> wrote:
> I was glancing through the install instructions today, and noticed that we tell
> people to GRANT ALL privileges which seems a bit... excessive.
>
> I searched through core and came up with the following list of required privileges:
>
> Data
> ====
> SELECT
> INSERT
> UPDATE
> DELETE
>
> Structure
> =========
> CREATE
> ALTER
> INDEX
> DROP
> CREATE TEMPORARY
>
> Admin
> =====
> LOCK TABLES
>
> Could someone take a look and let me know... Am I missing any? Are there things
> here that shouldn't be?
>
> -Angie
>
> P.S. I know we're only supposed to work on 4.7 RC stuff, but this is for some
> training stuff I'm doing to hopefully get more developers to work on Drupal,
> including testing and reviewing patches to help the 4.7 RC! ;)
>
>


More information about the development mailing list