Odoo Help


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


Changed admin username and now have minimal rights

on 5/7/13, 8:20 AM 2,247 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!




| 6 5 8
Delhi, India
Python OpenERP Developer http://in.linkedin.com/pub/sandeep-rana/3b/a16/786/
On 5/7/13, 8:23 AM

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

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

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.




| 5 6 8
Cornwall, Canada

Analysing, designing, coding and mentoring since 1975. Kilobytes to terabytes. Punch cards to punchy sites. My OpenERP video series: http://www.youtube.com/playlist?list=PLq7op4J183lX44ZlXPiHxUpRvmmRDtxye My Google Speadsheets --> OpenERP Data Pump project: http://martinhbramwell.github.io/GData_OpenERP_Data_Pump My email (with spaces removed) : mhb . warehouseman @ gmail . com

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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)


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