Forum Discussion

v-vemami's avatar
v-vemami
Helper
4 years ago

User Details

Need total userdetails(username,mailid,fullname,role)

  • Hello v-vemami ,

    To get details of a particular user and their roles:

    User Details:

    SELECT login,first_name,last_name,email FROM users WHERE id = 'USER_ID'

    User Roles:

    SELECT id, name FROM roles WHERE users.id = 'USER_ID'

    If my response helped you, please give kudo and accept as solution.
    Thank you!