Skip to Content
Menu
This question has been flagged
2 Replies
1724 Views

Hello, I have a big problem.

the admin rights of my main user are lost. I can't go to development settings or change anything. What can I do?

How can I get a new admin user?



Greetings 



Avatar
Discard
Best Answer

One way to solve this is by logging in as super user (odoo bot). The super user will have same credentials as admin but full rights, even the rights restricted to admin.


Another way to solve this is by executing a query. Go to pg admin and execute this query. insert into res_groups_users_rel (gid, uid) values (2, 2);

First argument 2 is the record id of Administration group and Second argument 2 is the id of the admin user. (1 will always be odoo bot).


Avatar
Discard
Author

Hi John,

What/where is "pg admin"?

Author

Hi John,
Where can I find login per superuser?
In my login there are noch possibility to chose superuser. I am using odo16

Author Best Answer

Hi John,

What/where is "pg admin"?

Avatar
Discard

Pg admin is an application used for Postgres which is the SQL used for odoo. You can use pg admin to see or manipulate the database and tables used in odoo. You can refer this article if you need more details : https://www.cybrosys.com/odoo/odoo-books/odoo-15-development/ch2/

Author

Hi John,
my web-skills are to low. I have problems to login about pgadmin. My host name is wrong?!