Odoo Help


in which table user name go to store in openerp 7 [Closed]

on 5/7/13, 8:27 AM 6,292 views

The Question has been closed

Sudhir Arya (SA)
on 02/07/2014 23:51:50

in which table user name go to store in openerp 7

On 5/7/13, 10:10 AM
01_test=> select u.id, u.login, u.signature, p.name, p.id 
            from res_users u, res_partner p
           where u.login = 'leow' 
             and p.id = u.partner_id;
 id | login |    signature    |    name    | id 
  4 | leow  | Leonardo Wilder | Leo Wilder | 59
(1 row)

good answer thank you very much

on 5/8/13, 1:34 AM
Sudhir Arya (SA)
On 5/7/13, 8:32 AM

Object name is res.users and table name is res_users and field name is login that is used as user name.

res.users inherits res.partner so name field is used from res.partner. Thus you cannot see name field in res.users table.

name is not going to store in that table there is a login field it's only having a char value

on 5/7/13, 8:40 AM

Yes, user name and password are store in this table. That login is used as user name.

Sudhir Arya (SA)
on 5/7/13, 8:43 AM

in res_users from there is field (Name,Login) -->login field there in table then where is the name field going

on 5/7/13, 8:52 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:27 AM
Seen: 6292 times
Last updated: 3/16/15, 8:10 AM