Skip to Content
Menu
This question has been flagged
1 Odpoveď
3327 Zobrazenia

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
Zrušiť
Best Answer

Users are created from within Odoo, not from within PostgreSQL

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

Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
2
mar 25
7349
1
aug 23
2483
0
nov 21
3505
1
okt 25
512
2
okt 25
665