• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums General SOx Compliance

Extracting a list of Lawson user IDs

 8 Replies
 1 Subscribed to this topic
 2 Subscribed to this forum
Sort:
Author
Messages
ryanhoag
New Member Send Private Message
Posts: 0
New Member
3/12/2008 12:55 PM

How can I extract a list of users from Lawson?

Better yet, does anyone know the name of the table that stores the user information (username, user's Security Class, active/inactive, etc.)?

This client does not have Monarch, so I'm hoping I can have their DBA run a query in Oracle if there is no easy way to do it straight from the app itself.

Thanks-

Chris Martin
Veteran Member Send Private Message
Posts: 277
Veteran Member
3/12/2008 1:53 PM
The table name is USER. It's not stored on the db. You can access using Lawson app utilities or via a dme call.
k-rock
Veteran Member Send Private Message
Posts: 142
Veteran Member
3/12/2008 1:55 PM
you could run the User ID listing from the LAUA security forms if you can't get to the USER table. This report has the data you're looking for, you would need to get it into a nicer format though.
John Henley
Send Private Message
Posts: 3351
3/12/2008 2:26 PM

If you are running LSF9, the GEN / USER table is stored in the RDBMS, so you can query it from Oracle. 

Thanks for using the LawsonGuru.com forums!
John
0
liked by Members
Chris Martin
Veteran Member Send Private Message
Posts: 277
Veteran Member
3/12/2008 5:39 PM
Sorry, still a noob when it comes to LSF9...thanks for clarifying.
amylynanderson
Advanced Member Send Private Message
Posts: 26
Advanced Member
8/26/2008 10:54 AM
The gen user file does not contain last login information. Is there a table to get that information?
John Henley
Send Private Message
Posts: 3351
8/26/2008 1:19 PM
Which platform / OS ? Which Env/LSF9?
Thanks for using the LawsonGuru.com forums!
John
0
liked by Members
John
New Member Send Private Message
Posts: 1
New Member
2/5/2009 2:53 PM
What is the name of the file on the iSeries, how would we query it from Crystal?
Deleted User
New Member Send Private Message
Posts: 0
New Member
4/17/2009 11:47 AM
Posted By John Henley on 08/26/2008 09:19 AM Which platform / OS ? Which Env/LSF9?

John-

We are running 9.0.0 on NT with LSF9 and we are having this same issue right now.  My auditors are eating me alive, and I'm new to the Lawson world.  Before I came in, Auditing + Logging was not even enabled so I would I not be able to get a record of when and how users were set up and by whom?