AnsweredAssumed Answered

Is it possible to not grant all mysql permissions?

Question asked by nicholasdipiazza on Mar 29, 2012
Latest reply on Mar 30, 2012 by mitpatoliya
When configuring Alfresco 3 or 4 with MySQL as the database backend, the documentation all states you do this to create the database and alfresco user:

mysql> CREATE DATABASE alfresco;
mysql> CREATE USER 'alfresco'@'localhost' IDENTIFIED BY '<password>';
mysql> GRANT ALL PRIVILEGES ON alfresco.* TO 'alfresco'@'localhost';

But To comply with the principal of least permission, we are wondering… is there really a need for ALL priviledges for the alfresco user? What ones could we eliminate safely, if any?

-Nicholas

Outcomes