Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How do I see what repositories each user or group has access to?

I need to find out what repositories and projects each user has access to and what level of access they have. Something similar to the Permission Helper in Jira but for Stash would work great. It would be ideal to see the repositories and/or projects on the user's profile page as an administrator (or maybe a link to acquire the list quickly).

Does this exist?

5 answers

1 accepted

4 votes
Answer accepted

I guess we may end up writing a plugin for this fundamental functionality...

Please publish it if you really do, I would use it too.

I know the original question is old, but the following queries might help somebody:

 

select distinct(group_name) from sta_project_permission order by group_name;
select distinct(group_name) from sta_repo_permission order by group_name;
select distinct(group_name) from sta_global_permission order by group_name;

 

According to postgres, these appear to be all the tables with a group_name column:

  • cwd_app_dir_group_mapping
  • cwd_group
  • sta_global_permission
  • sta_project_permission
  • sta_repo_permission

I also searched for group_id and got:

  • cwd_group_attribute

 

So while the three queries above may not be complete, the column name searches lead me to believe I'm good.

Just an update for something a little more informative.

 

Repository permissions:

SELECT
  group_name as "Group",
  project_key as "Project Key",
  repo_name as "Repository Name",
  project_name as "Project Name"
FROM
  sta_repo_permission srp
  INNER JOIN (
    SELECT
      repository.id, repository.name as repo_name, project.name as project_name, project.project_key
    FROM repository
    INNER JOIN project on repository.project_id = project.id) repo on srp.repo_id = repo.id
WHERE
  group_name is not null;

 

Project permissions:

SELECT
  group_name as "Group",
  name as "Project Name",
  project_key as "Project Key"
FROM
  sta_project_permission spp
  INNER JOIN project on spp.project_id = project.id
WHERE
  group_name is not null;
Like Pete Timmins likes this

Thanks Mark! 

I haven't seen anything like this existing yet

A possible solution might be using the REST-API (https://developer.atlassian.com/static/rest/stash/3.0.1/stash-rest.html#idp788096) perfroming the following steps:

Hint: you have to be admin to get a comprehensive list of ALL repositories ...

Do we still not have this feature?

Nope, as often with Atlassian essential tools are not provided.

This is really annoying and just leads to us contacting support when it happens.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Bitbucket

Powering DevOps with Bitbucket Server & Data Center

Hi everyone, The Cloud team recently announced 12 new DevOps features that help developers ship better code, faster   ! While we’re all excited about the new improvements to Bitbucket ...

1,926 views 0 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you