Minimum MySQL Permissions?

What are the minimum MySQL user permissions required to run Dolphin?

 

SELECT, UPDATE, INSERT, DELETE

any others?

Quote · 7 Feb 2012

Hi! you forget CREATE

so much to do....
Quote · 7 Feb 2012

ALTER, INDEX and DROP will also be required. And a maybe others. This is not documented anywhere.

This is the first time anyone has ever asked this question. Most people just enable all privileges except the admin privileges of GRANT, LOCK TABLES and REFERENCES.

You never know what will be needed in future versions of dolphin and there is no point it taking the risk of missing privileges.

https://www.deanbassett.com
Quote · 7 Feb 2012

I just need to know what the basic ones are to run the system because I want to secure the site as much as possible

 

ALL PRIVILEGES
ALTER CREATE
CREATE ROUTINE CREATE TEMPORARY TABLES
CREATE VIEW DELETE
DROP EXECUTE
INDEX INSERT
LOCK TABLES REFERENCES
SELECT UPDATE
Quote · 8 Feb 2012

You can't secure your site like that because you have to give the basic permissions which is enough for anyone to retrieve or insert data in DB. As Deano said there is no documentation of what privileges is needed for dolphin so you might get errors and that will be a real pain. 

so much to do....
Quote · 8 Feb 2012
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.