Skip to Content
Menu
This question has been flagged
1 Atsakyti
3328 Rodiniai

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.


Portretas
Atmesti
Best Answer

Users are created from within Odoo, not from within PostgreSQL

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

Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
2
kov. 25
7349
1
rugp. 23
2483
0
lapkr. 21
3505
1
spal. 25
512
2
spal. 25
665