Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
1 Rispondi
3545 Visualizzazioni

Hello everyone,

I started exploring the various features of Odoo.sh yesterday and I would like to know how to add a user who can access the database. Currently, after entering the Odoo.sh shell, I use the psql command to access the database. When I try to create a user by entering: CREATE USER readonly_user WITH PASSWORD 'readonly_user';


I receive a "permission denied to create role" error.

Additionally, when I run the command odoosh-sql-access status in the Odoo.sh shell, it shows "PostgreSQL External Access is only available on Odoo.sh dedicated servers."

Could anyone guide me on how to resolve this issue and successfully create a database user?


Thank you.


Avatar
Abbandona
Risposta migliore

Users are created from within Odoo, not from within PostgreSQL

See https://www.odoo.com/documentation/master/applications/general/users.html

Avatar
Abbandona
Post correlati Risposte Visualizzazioni Attività
2
mar 25
7568
1
ago 23
2579
0
nov 21
3600
1
ott 25
535
1
ott 25
733