Which database table holds user roles

  • dasigrist

    (@dasigrist)


    5 years, 11 months ago

    Hi all,

    we created several user roles on ultimate member. There are 2 columns there, Role Title and Role ID.
    I was able to find the Role ID on the wp_usermeta table. There we have the umeta_id, user_id, meta_key and meta_value. The meta_key capabilities have the meta_value “a:1:{s:6:”vendor”;b:1;}” where vendor is the Role ID. But there is no meta_value with the Role Title.

    My boss wants a simple dashboard with the number of users per role, but I would like to show the role title and not the role id.

    Does anybody know which table has the role title?

    Thank you.

The topic ‘Which database table holds user roles’ is closed to new replies.