Skip to Content
Menu
This question has been flagged
1 Reply
3183 Views

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
Discard
Best Answer

Users are created from within Odoo, not from within PostgreSQL

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

Avatar
Discard
Related Posts Replies Views Activity
2
Mar 25
7214
1
Aug 23
2404
0
Nov 21
3419
1
Oct 25
378
2
Oct 25
539