Odoo Help


I cut the branch of the tree where i sit...!!!

aci aisha
on 1/19/15, 7:17 AM 784 views

I was the admin.

I remove the admin power myself.

Now no Settings menu for me...

What should i do now.............???

do you mean you have deleted the admin user??

Emipro Technologies Pvt. Ltd.
on 1/19/15, 7:37 AM
Abin C I
On 1/19/15, 7:37 AM

1.Go to pgadmin

2.Open the table 'res_groups_users_rel'

3.Insert a query like foloows,

INSERT INTO res_groups_users_rel( gid, uid)VALUES (4, 1);

4.Execute it

5.Then refresh odoo page

Hope it helps...

Great Abin, It works...Thank you very much...

aci aisha
on 1/19/15, 7:37 AM



| 5 4 6
Zagreb | Karlovac, Croatia

there is only 10 kind of people the ones that understand binary ... and others

On 1/19/15, 7:27 AM

Well.. you should know one thing : 
there is ONE and only one admin user with UID = 1...

Once deleted, you may try to change the ID field of res_users table to 1, in order to make that user superuser.. 

but that is not recomended... even if you know db administration and odoo more than average.. 


it you are at novice level.. only thing left for you is to create new database.. 
and remember NOT to delete ADMIN user ever!... you can rename it at your will..

because no other user will ever get UID 1, and gain unrestricted superuser status in odoo... 

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 1/19/15, 7:17 AM
Seen: 784 times
Last updated: 3/16/15, 8:10 AM