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.
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
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot