Roles & Privileges Assignment Report in Dimensions RM Hot

by Matthew Ong on January 15, 2017

Currently, the system administrator can view the roles and privileges assignment in RM Manage.  The system administrator is unable to generate a report to view the assignment

  • Currently, the system administrator can view the roles and privileges assignment in RM Manage.  The system administrator is unable to generate a report to view the assignment.  The idea is to allow System Administrator to generate a report for the following:

    1.  Roles & Privileges Assignment Report

    2.  User associated with the roles

    The report must allow the System Administrator to filter by Roles & User Id.

    Ideas

  • Please login to view any attachments.

  • Already have an account? or Create an account
    Role/privilege reports are a good idea. I personally went into the RM data tables and am currently doing sql queries to put that data into a spreadsheet based on user groups.
    The first column shows the user's group and the first row has all the user names listed. There is a X in each box where a user exists in any given group. It's not the most robust type of 'report', but perhaps somewhere that the RM team can start. That idea only has to do with group-user relations. There are a plethora of privileges involved that could be reported on in various ways.
    In my case, I send the spreadsheet to the customer where they mark up the spreadsheet with desired changes to their user privileges. When I get the spreadsheet I look for the highlighted changes.
    When I get extra time, I will likely make another program for looking at the differentials in the X marks on the spreadsheet to have a program add/remove privileges for me based on spreadsheet changes. Those are all ideas that Serena could utilize in some fashion or form. I wouldn't give an end user admin because of all the stuff they would have access to and I don't want them to have the ability to change whoever's privileges unless I could narrow them down to only that user's usergroup. I have multiple organizations in my RM setup and even multiple organizations within some RM projects.
    Joshua Trosclair Commented by Joshua Trosclair March 03, 2017
    Top 50 Reviewer  -  

    Role/privilege reports are a good idea. I personally went into the RM data tables and am currently doing sql queries to put that data into a spreadsheet based on user groups.
    The first column shows the user's group and the first row has all the user names listed. There is a X in each box where a user exists in any given group. It's not the most robust type of 'report', but perhaps somewhere that the RM team can start. That idea only has to do with group-user relations. There are a plethora of privileges involved that could be reported on in various ways.
    In my case, I send the spreadsheet to the customer where they mark up the spreadsheet with desired changes to their user privileges. When I get the spreadsheet I look for the highlighted changes.
    When I get extra time, I will likely make another program for looking at the differentials in the X marks on the spreadsheet to have a program add/remove privileges for me based on spreadsheet changes. Those are all ideas that Serena could utilize in some fashion or form. I wouldn't give an end user admin because of all the stuff they would have access to and I don't want them to have the ability to change whoever's privileges unless I could narrow them down to only that user's usergroup. I have multiple organizations in my RM setup and even multiple organizations within some RM projects.

     

PrintEmail

Recent Tweets