Odoo Help


Changed admin username and now have minimal rights

on 5/7/13, 8:20 AM 3,346 views

Hi, I changed the admin username in the settings of OpenERP 7.0 and now when I log in I have minimal rights in the settings screen and cannot undo my changes.

Does anyone know how I can reset the admin user?

Thanks in advance!



Hi Mr. Nathan ,

did you change login field value , plz be that "admin"

it might be used in domin (for security) for various model (object)

just change value of User field

then there will no be any effect for access

Yes, I changed the login field value in the user settings. How can I change the value of the "User field", where can I find this?

on 5/7/13, 8:26 AM

just let it be same (admin) just change the user field value for display purpose, "admin" might be used in access right rule , that why you can't see all the accessibility

ClueLogics Technologies Pvt. Ltd.
on 5/7/13, 8:27 AM

problem is that I can't change any user settings anymore........

on 5/7/13, 8:28 AM

you can change,, just change name according to you , don't change login

ClueLogics Technologies Pvt. Ltd.
on 5/7/13, 8:30 AM

that's my problem, I can't change any user settings anymore, the "users" menu has disappeared since changing the username.

on 5/7/13, 9:26 AM
On 1/4/15, 11:45 PM

Hi Nathan,

Were you able to find a solutions to your problem, I have a same problem

Viet Nguyen
On 5/26/13, 10:01 PM
  1. Log into your PostgresSQL database
  2. Run this to find the User ID of your admin user: select id,login from res_users;
  3. Run this to give you access back to the settings: Insert into res_groups_users_rel values (the_id_found_in_step_2, 2);

Hope it helps.


On 5/7/13, 9:57 AM

I suspect your only hope is to edit the database. :-(

Although it answers a different question, you might learn how you can do that from this post : https://accounts.openerp.com/forum/Help-1/question/478#487

Your problem, I think, is that the label admin has special significance in OpenERP, just like root has special significance in Unix systems. If you want to always use a different UID, (as is considered best practice in most operating systems), you need to create a new user for that, and give as many privileges as possible to that user.

Even then, that user may have some limitations.

thanks, I've edited res_users in the database and changed user with ID "1" back to "admin", unfortunately after logging in I still can't see all the menu's in "Settings". Do I need to change anything else?

on 5/7/13, 10:21 AM

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

0 follower(s)


Asked: 5/7/13, 8:20 AM
Seen: 3346 times
Last updated: 3/16/15, 8:10 AM