User Details
Need total userdetails(username,mailid,fullname,role)
Forum Discussion
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!
