How to get a list of all users that inherit access to Fisheye and Crucible through groups

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

Purpose

Access to Fisheye and Crucible is managed inside the global permissions page and is set on a per-group or per-user basis. The purpose of this knowledge base article is to show you how to get a list of all users that have access to Fisheye and Crucible based on the groups they belong to and have been granted access to the applications inside the global permissions page directly from the database.

Solution

Since both applications (Fisheye and Crucible) are licensed separately (i.e. user seats are counted separately) you'll need two select queries:

Users with access to Fisheye (controlled by Global Permissions > Groups)
select distinct cu.user_name
  from cwd_user cu
  join cwd_membership cm
    on cu.id = cm.child_id
  join cru_global_group_permission cggp
    on cm.parent_name = cggp.cru_group_name
 where cggp.cru_global_permission = 'FISHEYE_USER'
   and cu.active = 'T';
Users with access to Crucible (controlled by Global Permissions > Groups)
select distinct cu.user_name
  from cwd_user cu
  join cwd_membership cm
    on cu.id = cm.child_id
  join cru_global_group_permission cggp
    on cm.parent_name = cggp.cru_group_name
 where cggp.cru_global_permission = 'CRUCIBLE_USER'
   and cu.active = 'T';

The select queries above were built for PostgreSQL 9.6. You may need to adjust them to work with other databases e.g. Oracle, MySQL and etc.

DescriptionList of all users that inherit access to Fisheye and Crucible through groups
ProductFisheye, Crucible
Last modified on Mar 5, 2021

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.