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

Listing the bursting rights by user

 3 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Donna
Veteran Member
Posts: 110
Veteran Member
5/23/2014 6:52 PM
    I can create a number of reports from Lawson FS and RS but I can't find a table that has the rights for a user.

    Does a table that has this information exist?

    Example

    User Department Rights
    Me 1000
    2000
    3000
    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
    5/23/2014 7:06 PM
      See my response here: https://www.lawsonguru.co...ghts-info-in-report/
      amynelson
      Advanced Member
      Posts: 25
      Advanced Member
      5/23/2014 7:07 PM
        It will be a combination of fields from the following tables:

        dbo.ERS_RULEMAPPINGS
        dbo.ERS_RULEVALUES
        dbo.ERS_ELEMENTS
        dbo.ERS_RULEMASTER
        dbo.ERS_STRUCTURETEMPLATE
        Donna
        Veteran Member
        Posts: 110
        Veteran Member
        5/23/2014 7:13 PM
          Amy and Greg,

          Thank you for answering me so quickly.

          I downloaded Greg's Report and added information from Active Directory. The result meets my current requirements perfectly.

          Thank you so much!

          Donna