• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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