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
Posts: 1
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-

    0
    Chris Martin
    Veteran Member
    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.
      0
      k-rock
      Veteran Member
      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.
        0
        John Henley
        Posts: 3353
        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
          Veteran Member
          Posts: 277
          Veteran Member
          3/12/2008 5:39 PM
            Sorry, still a noob when it comes to LSF9...thanks for clarifying.
            0
            amylynanderson
            Advanced Member
            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?
              0
              John Henley
              Posts: 3353
              8/26/2008 1:19 PM
                Which platform / OS ? Which Env/LSF9?
                Thanks for using the LawsonGuru.com forums!
                John
                0
                John
                New Member
                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?
                  0
                  Frank Z
                  Advanced Member
                  Posts: 32
                  Advanced 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? 

                     

                    0