Audit permission on all projects and repositories

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Duplicate
    • None
    • Component/s: None
    • None

      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

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

              Created:
              Updated:
              Resolved: