PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 4/17/2009 11:47 AM by  Frank Z
Extracting a list of Lawson user IDs
 8 Replies
Sort:
You are not authorized to post a reply.
Author Messages
ryanhoag
New Member
(1 points)
New Member
Posts:1


Send Message:

--
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-
    0
    Chris Martin
    Private
    Private
    Veteran Member
    (825 points)
    Veteran Member
    Posts:277


    Send Message:

    --
    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.
    0
    k-rock
    Private
    Private
    Veteran Member
    (416 points)
    Veteran Member
    Posts:142


    Send Message:

    --
    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.
    0
    John Henley
    Private
    Private
    Senior Member
    (9911 points)
    Senior Member
    Posts:3321


    Send Message:

    --
    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
    Chris Martin
    Private
    Private
    Veteran Member
    (825 points)
    Veteran Member
    Posts:277


    Send Message:

    --
    3/12/2008 5:39 PM
    Sorry, still a noob when it comes to LSF9...thanks for clarifying.
    0
    amylynanderson
    Private
    Private
    Advanced Member
    (64 points)
    Advanced Member
    Posts:26


    Send Message:

    --
    8/26/2008 10:54 AM
    The gen user file does not contain last login information. Is there a table to get that information?
    0
    John Henley
    Private
    Private
    Senior Member
    (9911 points)
    Senior Member
    Posts:3321


    Send Message:

    --
    8/26/2008 1:19 PM
    Which platform / OS ? Which Env/LSF9?
    Thanks for using the LawsonGuru.com forums!
    John
    0
    John
    Private
    Private
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    2/5/2009 2:53 PM
    What is the name of the file on the iSeries, how would we query it from Crystal?
    0
    Frank Z
    Advanced Member
    (82 points)
    Advanced Member
    Posts:32


    Send Message:

    --
    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? 

     
    0
    You are not authorized to post a reply.

    Forums General SOx Compliance