For most of the user information, you'll need to read cwd_user. For their groups, read cwd_membership. Then for their roles, read projectroleactor, remembering that their groups could also be used in roles.
Why do you want to do this though? It's probably a dreadfully complex way to achieve what you're trying to do.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
...attest to the experience of an urgent approval that gets lost in the boss’s inbox and requires that special “Please Approve” email or text message. In an age where we have distributed teams...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG