Forums
Lawson Business Intelligence/Reporting/Crystal
Listing the bursting rights by user
Author
Messages
Donna
Veteran Member
Posts: 110
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
5/23/2014 7:06 PM
See my response here:
https://www.lawsonguru.co...ghts-info-in-report/
amynelson
Advanced Member
Posts: 25
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
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