User Roles and Permissions
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 |
|
Tuesday, May 1, 2012, 1:37:37 PM |
1
|
Each user can see their permissions in the "Profile" page (top right), click on the permissions section to expand it. |
||||
|
0
|
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? |
||||
|
0
|
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). |
||||
|
0
|
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. |
||||
|
0
|
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. |
||||
|
0
|
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! |
||||
|
0
|
ANSWER
There you go: AdministerProject = 1, |
||||
|