Skip to Content
This question has been flagged
2 Replies
3736 Views
Avatar
jeanphilippedemaison@gmail.com

Hi everyone,

I was looking through my user settings and changed the "Administration" line from "Configuration" to "Access rights in Users\"Myuser". 

So I can no longer access the application and developer menu.

I have my user ID and I would like to know the psql command to change the value again.


Thank you in advance for your help!

Avatar
Discard
Avatar
jeanphilippedemaison@gmail.com
Author Best Answer

Thank you for your answer Xavier.


Unfortunately my problem was different. I had to use the command : 

INSERT INTO res_groups_users_rel (gid,uid) VALUES (3,2);

Fortunately, it worked. 

But now I can't access global settings from one of the companies ( multi company setup ) with this error in logs :

odoo.models: Impossible d'effectuer l'opération demandée, en raison des règles d'enregistrement : Type de document : crm.team, Opération : read, Enregistrements : 4, Utilisateur : 2

Which should look something like this in english : 

odoo.models: Impossible to perform the requested operation, due to the registration rules: Document type: crm.team, Operation: read, Records: 4, User: 2



I can access the menu when i'm on the other company though which is very weird.

Avatar
Discard
Ermin Trevisan

Check the allowed companies for your user and adapt it.

Avatar
Xavier Brochard
Best Answer

This is a FAQ. See this extensive answer from Erwin Trevisan
https://www.odoo.com/forum/help-1/question/how-to-reset-the-odoo-database-admin-password-a-summary-for-different-odoo-versions-131992

Avatar
Discard