MyBB Community Forums
[Security] SQL Permissions - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Community Archive (https://community.mybb.com/forum-106.html)
+--- Forum: Archived Forums (https://community.mybb.com/forum-143.html)
+---- Forum: Archived Development and Support (https://community.mybb.com/forum-155.html)
+----- Forum: MyBB 1.6 (https://community.mybb.com/forum-138.html)
+------ Forum: 1.6 General Support (https://community.mybb.com/forum-127.html)
+------ Thread: [Security] SQL Permissions (/thread-101873.html)



SQL Permissions - MisterW - 2011-08-17

[Image: sqlperm.png]

What are the required boxes above that need to be ticked for my forums database? as I read somewhere that the main users for the database shouldn't have full permissions incase SQL injections are made.


RE: SQL Permissions - pavemen - 2011-08-17

well you need:

ALTER for plugins that modify tables
DROP for plugins that remove tables when they uninstall
INDEX for using MyBB full text
SELECT for queries
CREATE for MyBB install and plugin install
DELETE for MyBB edits, etc
INSERT for new data
UPDATE for updated data


RE: SQL Permissions - MisterW - 2011-08-17

(2011-08-17, 01:50 AM)pavemen Wrote: well you need:

ALTER for plugins that modify tables
DROP for plugins that remove tables when they uninstall
INDEX for using MyBB full text
SELECT for queries
CREATE for MyBB install and plugin install
DELETE for MyBB edits, etc
INSERT for new data
UPDATE for updated data

Thank you, I have updated permissions now. Smile