topic Is it possible to not grant all mysql permissions? in Alfresco Archive

Is it possible to not grant all mysql permissions?

nicholasdipiazz — Thu, 29 Mar 2012 14:37:57 GMT

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 al

Re: Is it possible to not grant all mysql permissions?

mitpatoliya — Fri, 30 Mar 2012 06:28:27 GMT

Yes, you require to have all the previlages for alfresco user on the DB.
As by default whenever alfresco do some changes in the db it will do this with this user.
If you changes the permission you will get the error when you change something from front end.
As it will also go and try to update the db accordingly.