web.geek Posted March 23, 2011 Share Posted March 23, 2011 Installing 1.4.0.17, and I understand that the database user during the install process needs all privileges so it can create all of the objects. I would like to change that user in the config/settings.inc.php file after the install to one with fewer privileges for the operation of the site. I imagine it would only need SELECT, INSERT, UPDATE, and DELETE (perhaps REFERENCES) privileges, but I wonder if anyone has a definitive answer.What are the minimum database user privileges needed by the _DB_USER_ for the application to fully function?Thanks Link to comment Share on other sites More sharing options...
cleatus Posted April 28, 2011 Share Posted April 28, 2011 i'm wondering the same thing. also, does anyone know of a recent security related tutorial or list of recommendations for putting prestashop in paranoid mode? things one can do on a shared host? Link to comment Share on other sites More sharing options...
numberMumbler Posted October 17, 2014 Share Posted October 17, 2014 SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTERhttp://doc.prestashop.com/display/PS14/System+Administrator+Guide#SystemAdministratorGuide-OneMySQLuserperwebapplication Old thread, but it came up near the top of my search Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now