Details
-
Suggestion
-
Resolution: Duplicate
-
None
-
None
-
None
Description
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
Attachments
Issue Links
- duplicates
-
BSERV-3075 Audit logging
- Closed