Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Users attached to Rights

 3 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Ruma Malhotra
Veteran Member
Posts: 412
Veteran Member
9/30/2009 3:23 PM
    We have more than 350 rights in LBI that are present. I have written reports that tells me by which structure, which rolee are attached to which elements.

    However I cannot find which users are attached to which right in LBI.

    Has anybody found an eaier way of getting this information ?

    tia
    ruma.
    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
    9/30/2009 9:04 PM
      If you are at least semi-current in your version of LBI: All of the rules are contained in the ERS_RULEMASTER table.
      From there you can easily write a crystal report to tie to the ERS_RULEMAPPING table via RULEID field to get the actual login names. Or is that not what you are requesting here?
      Nancy
      New Member
      Posts: 1
      New Member
      10/1/2009 11:49 AM

        Are you using Custom Groups?  We attach our users to a custom group and then attach the custom group to the Rights.   I have a crystal report that shows which users are in which custom group.  If you have the same setup, I'd be glad to share my crystal report with you.

        Nancy

        Ruma Malhotra
        Veteran Member
        Posts: 412
        Veteran Member
        10/5/2009 2:21 PM
          @ Greg - We are on LBI 9.0.3.1.156. On the ERS_RULEMAPPINGS table there is a consumerid which is the name of the role, tyhe consumer type field and a rule_id.

          We can link the rule_id field of the ERS_RULEMAPPINGS table to the rue_id of the ERS_RULEMASTER but there is no login id field to get the users attached to the rights. In fact none of these tables look like they have any information regarding the user-ids attached to the rights unless somone has written an LDAP query and only if that is possible to get the information.

          thanks,
          Ruma.