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.
I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...
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