Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

3

Does the PostgreSQL user for Odoo HAVE to be a 'superuser' (as documented)?

v8 v7
By
Ray Carnes
on 1/8/15, 6:22 PM 1,330 views

The documentation at https://doc.odoo.com/install/linux/postgres/#setup-a-postgresql-user-for-openerp states "Make this new user a superuser", instructing us to give the PostgreSQL user used by Odoo to access the database without any permission restructions.

Database administrators have always been wary of this and in checking with others in my company, we have several systems running without this role, just with create database permissions. 

Does anyone know if anything will not be available, or will not work, if superuser access is not permitted?

1
Steve Switzer
On 1/8/15, 9:38 PM

Not as far I I know. My installation is working fine with just the 'create database' permission. Try it and see what happens. It worked for me.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 1/8/15, 6:22 PM
Seen: 1330 times
Last updated: 3/16/15, 8:10 AM