Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
LBI Security Groups
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Wayne Willis
Past 24 Hours:
1
Prev. 24 Hours:
1
Overall:
5190
People Online:
Visitors:
130
Members:
0
Total:
130
Online Now:
New Topics
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1351
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson Business Intelligence/Reporting/Crystal
LBI Security Groups
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Tim
Basic Member
Posts: 12
2/22/2011 11:33 PM
What table in the LBI meta model relates to ERS_SECURITYGROUPS and identifies all of the users assigned to it?
I would like write a SQL query to identify the individuals that are assigned to a security group.
Thanks,
Tim
Matthew Nye
Veteran Member
Posts: 514
2/23/2011 7:19 AM
Tim,
I noticed you said you found the ERDs for LBI. What do you mean by this? As far as I know there is no published ERD for the LBI repository. If you have them I would LOVE to get my hands on them.
The table youre looking for is ERS_REPORTACCESS. They use a fake report ID to map all security groups.
SELECT SECURITYGROUPNAME GroupName, ACCESSVALUE UserName
FROM ERS_REPORTACCESS ra
INNER JOIN dbo.ERS_SECURITYGROUPS sg ON ra.JOBNAME = sg.SECURITYGROUPID
WHERE ra.REPORTID = -99 AND INSTANCEID = -99
ORDER BY SECURITYGROUPNAME, ACCESSVALUE
Again, this is just my own discovery. None of this is documented (read: supported) by lawson. Much of the SQL they use is prepared in their compiled code so its a bit difficult, if not time consuming, to translate.
hth
Matt
Tim
Basic Member
Posts: 12
2/23/2011 2:30 PM
Thanks Matt! I really appreciate it.
I have verified your query against some roles we have set up and the users assigned. It is accurate.
I knew that ERS_REPORTACCESS held the users and groups that had access to a report, but would have never guessed that a fake report ID would be used to define the users assigned to a group. I was expecting a table similar to ERS_LISTUSERS.
Here is where I found for ERDs...there are on this site.
1. Go to
https://www.lawsonguru.co...ch/DatabaseERDs.aspx
2. There are tabs defined for LBI-Framework Services, LBI-Reporting Services, and LBI-Smart Notifications.
I don't see a lot of relationships the reporting services diagram.
Thanks for your help!
Tim
Matthew Nye
Veteran Member
Posts: 514
2/23/2011 3:02 PM
Hmm, interesting. Hadnt see that John put these together. Lawson has never published any documentation similar to the ERP applications (data definition or tech docs). RS has very few defined relationships as they are enforcing data integrity on the business logic layer.
I would encourage you to check your logic for any programming you do against the repository everytime you upgrade LBI as the ERD has been known to change dramatically between even minor versions.
Ruma Malhotra
Veteran Member
Posts: 412
3/28/2011 6:45 PM
In the table ERS_REPORTACCESS, ers_Securitygroups
reportid=-99 and instanceid =-99 gives the list of all users that belong to a security group.
You are not authorized to post a reply.