Retrieving users and groups from a database
We can find all the information about JIRA users and their groups from the database by running a few simple SQL queries. In this recipe, we will see the various tables involved.
JIRA uses Embedded Crowd as its user management framework. Here, the users are stored in the cwd_user
table, groups are in the cwd_group
table and the membership details are in the cwd_membership
table. It is possible to have the group-user membership or the group-group membership, the latter for nested groups, and this information is also stored in the cwd_membership
table. User attributes are stored in the cwd_user_attributes
table and Group attributes are stored in the cwd_group_attributes
table.
JIRA also have the concept of ...
Get JIRA Development Cookbook - Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.