PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 05/23/2014 3:13 PM by  Donna
Listing the bursting rights by user
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Donna
Private
Private
Veteran Member
(266 points)
Veteran Member
Posts:110


Send Message:

--
05/23/2014 2: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
    Private
    Private
    Veteran Member
    (4035 points)
    Veteran Member
    Posts:1439


    Send Message:

    --
    05/23/2014 3:06 PM
    See my response here: https://www.lawsonguru.com/forums/pm/lbi/display-burst-rights-info-in-report/
    amynelson
    Private
    Private
    Advanced Member
    (69 points)
    Advanced Member
    Posts:25


    Send Message:

    --
    05/23/2014 3: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
    Private
    Private
    Veteran Member
    (266 points)
    Veteran Member
    Posts:110


    Send Message:

    --
    05/23/2014 3: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

    You are not authorized to post a reply.