Just a quicky post. I use drupal for a number of sites, and always have to lookup the database permissions required. Here they are nicely summarized. Essentially what I do is create a new user for each site that I am going to create. That new user has exclusive permissions to a new schema that I create for the site. Then I grant the following access rights to the database:

I run Gallery 2 for my picture gallery, and recently decided it was time to lock her down. What I have done follows.