Hi,

I want to increase security and only give specific privileges to my limesurvey MySQL user. Right now it is set to "GRANT ALL PRIVILEGES ON" - I would like to change that, if possible.
What privileges are required as a minimum by the limesurvey to run without problems?

Thanks

Insert/update/delete/create/alter/drop/index should be the minimum permissions.

Thanks - I try that. Perhaps you know the answer to my other question found in this thread (link) - that issue seems to be a rather big security risk if left unfixed and may affect all old and new installations of LimeSurvey.

c_schmitz wrote:
Hmmm.... it doesn't work. Now I get an "Internal Server Error" when I try to log into admin panel. Something about settings_global that can't be found...
I tried to revert to "all privileges", and then it works again but that isn't a solution.

What else do I need to choose? Here are all the options:

ALTER, CREATE ROUTINE, CREATE VIEW, DROP, INDEX, LOCK TABLES, SELECT, TRIGGER, CREATE, CREATE TEMPORARY TABLES, DELETE, EXECUTE, INSERT, REFERENCES, SHOW VIEW, UPDATE

Add 'Select', too.

Thanks - That seems to work