This question has been flagged
2 Replies
2437 Views

I was the admin.

I remove the admin power myself.

Now no Settings menu for me...

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

Avatar
Discard

do you mean you have deleted the admin user??

Best Answer

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...

Avatar
Discard
Author

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

Best Answer

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..

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

Avatar
Discard