Lesson 3.1 — PostgreSQL Roles vs Odoo Users

Click on the "Edit" button in the top corner of the screen to edit your slide content.

Key Principle
Odoo requires:

  • CREATEDB
  • Full schema control
  • Extension access

Dev vs Production

Environment

Role

Development

Superuser

Production

Least-privilege + controlled extensions

Hands-On Lab

sudo -u postgres createuser -p 5433 --createdb --superuser --pwprompt odoo19

sudo -u postgres createdb -p 5433 -O odoo19 axm_project

Break/Fix Exercise

  • Remove CREATEDB
  • Restart Odoo
  • Observe failure

Rating
0 0

There are no comments for now.

to be the first to leave a comment.

1. What permission does Odoo critically require?