Database Permission Clarification

[MobileCS]

Could someone please clarify what database permissions are required for general use?

http://download.simplemachines.org/requirements.php

The database user must have at least the following privileges: SELECT, INSERT, UPDATE, DELETE, ALTER, and INDEX.
The database user must have the CREATE and DROP privileges during installation, conversion and some package installs.

It appears the DROP permission is required at all times (not just during installation, conversion & package installs).

When I removed the DROP permission and click on "Show new replies to your posts", it errors out with :

Code Select Expand


http://www.example.com/forum/index.php?action=unreadreplies
Database Error: DROP command denied to user 'forum'@'localhost' for table 'smf_topics_posted_in'
File: /www/example.com/httpdocs/forum/Sources/Recent.php
Line: 946

Is the CREATE permission also required at all times now?

[Illori]

if you install mods then create may be required depending on the mod.

[Arantor]

Create and drop are also needed for unread replies since it makes a temporary table for processing.

[MobileCS]

Create and drop are also needed for unread replies since it makes a temporary table for processing.

Thank you, that's all I needed to know.

Perhaps the requirements page should be updated to reflect this : http://download.simplemachines.org/requirements.php