Home Home
  login

Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




User Roles and Permissions

admin
security
database

Is there a way to run a query against the Gemini database to return all of the roles assigned to a current user? I am not able to find a table with roles in it. The closest thing I can fine is [gemini_globalsecurityschemeroles] which has [schemerole], but it doesn't seem to like to anything.

The function [gemini_getuser] seems like it is in the right direction, but it is referencing tables that do not exist (userroles, securityschemes).

Basically what I'd like to do is run a report to present to either users, or a group to let them know what their permissions are in Gemini. Right now it seems like the only way to do that is to copy the data from the Users Permissions page on a per user basis.

Thanks for any insight.

Terry Bradshaw
tlbradshaw
· 1 		tlbradshaw
Tuesday, May 1, 2012, 1:37:37 PM
Replies (7)
helpful
1
not helpful

Each user can see their permissions in the "Profile" page (top right), click on the permissions section to expand it.
Mark Wing
· 9108 		Mark Wing
Tuesday, May 1, 2012, 6:22:17 PM
helpful
0
not helpful

That's a good feature, but what if as an admin I wanted a report on what roles a user has or who belongs to a group?
tlbradshaw
· 1 		tlbradshaw
Tuesday, May 1, 2012, 6:52:14 PM
helpful
0
not helpful

Admins can go to the Administration -> Users section and edit the user in question to see the same view. To see who belongs to a group go to the group (Administration -> Global / Project Groups).
Mark Wing
· 9108 		Mark Wing
Tuesday, May 1, 2012, 7:11:48 PM
helpful
0
not helpful

Mark,

That's very close to what I want, but as of right now I have to copy each user and paste them into Excel or something. I would like to export this data to create a list of all users and their roles. I still can't get a list of Global Groups and the permissions each group has. It seems like there should be some reporting built in that would allow you to list all of the permissions a role has.

That is why I was trying to run a query on the actual database. So that I could export the data and use it in a presentation\training.
tlbradshaw
· 1 		tlbradshaw
Tuesday, May 1, 2012, 7:38:28 PM
helpful
0
not helpful

What you need to do is join a few tables together: users, global and project groups to the security scheme tables. It is not a simple query but you can look at the gemini_getallprojectsummaryissuesbytype stored procedure for a sample.
Mark Wing
· 9108 		Mark Wing
Wednesday, May 2, 2012, 7:51:21 PM
helpful
0
not helpful

What are meaning for the different schemeroles? I think I can get everything I need if I could just decode that.

Thanks for all you help!
tlbradshaw
· 1 		tlbradshaw
Wednesday, May 2, 2012, 9:31:57 PM
helpful
0
not helpful
ANSWER

There you go:

AdministerProject = 1,
AdministerIssues = 2,
CreateIssue = 3,
EditIssue = 4,
DeleteIssue = 5,
DeleteOwnIssue = 6,
LinkIssue = 7,
MoveIssue = 8,
SetIssueVisibility = 9,
CloseIssue = 10,
ResolveIssue = 11,
LinkSourceControlFiles = 12,
AssignResource = 13,
Assignable = 14,
AssignVersion = 15,
ManageRepository = 16,
UpdateProgress = 17,
LogTime = 18,
ManageTime = 19,
SetWatchers = 20,
BatchEdit = 21,
CreateComment = 22,
EditComment = 23,
EditOwnComment = 24,
DeleteComment = 25,
DeleteOwnComment = 26,
ViewTime = 27,
ViewOwnIssuesOnly = 28,
ViewProject = 29,
ViewSourceControlFiles = 30,
ViewWatchersVoters = 31,
ViewRepository = 32,
MarkClosingComment = 33,
ViewSchedule = 34,
ManageSchedule = 35,
EditOwnIssue = 36,
Planner = 37,
ViewTests = 38, AdministerTests = 39,
Mark Wing
· 9108 		Mark Wing
Thursday, May 3, 2012, 12:52:52 PM