Uploaded image for project: 'Bitbucket Data Center'
  1. Bitbucket Data Center
  2. BSERV-3541

Audit permission on all projects and repositories

XMLWordPrintable

    • Icon: Suggestion Suggestion
    • Resolution: Duplicate
    • None
    • None
    • None
    • We collect Bitbucket feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Due to security requirement, system administrator should be able to audit permissions on all projects and repositories from the admin page.

      Workaround:

      Select the permission from the database

      • Project permission
        SELECT a.perm_id, b.name AS projectname, b.project_key, a.group_name FROM sta_project_permission a, project b WHERE a.project_id=b.id AND a.user_id IS NULL;
        SELECT a.perm_id, b.name AS projectname, b.project_key, c.name AS username FROM sta_project_permission a, project b, stash_user c WHERE a.project_id=b.id AND a.user_id=c.id;
        
      • Repository permission
        SELECT a.perm_id, c.name AS projectname, c.project_key, b.name AS repository, a.group_name FROM sta_repo_permission a, repository b, project c WHERE a.repo_id=b.id AND b.project_id=c.id AND a.user_id IS NULL;
        SELECT a.perm_id, c.name AS projectname, c.project_key, b.name AS repository, a.group_name, d.name AS username FROM sta_repo_permission a, repository b, project c, stash_user d WHERE a.repo_id=b.id AND b.project_id=c.id AND a.user_id=d.id;
        
      • Permission level
        perm_id level
        0 read
        1 write
        2 read
        3 write
        4 admin
        8 admin

              Unassigned Unassigned
              klfoong Foong (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: