Prev
Next
Forums Lawson S3 Financials

Caputuring Lawson Application user for oracle trigger

Sort:
You are not authorized to post a reply.
Author
Messages
Todd Mitchell
Veteran Member
Posts: 87
Veteran Member
12/11/2009 6:50 PM

    We are trying to create a trigger in Oracle that will capture the user ID of the individual making a change within the Lawson Application.  Looking at the code within Lawson itself, it looks as if the application graps the CRT-USER-NAME.

    Is it possible to grab the application user signed on using an Oracle trigger?

    wilcoxmad
    Veteran Member
    Posts: 87
    Veteran Member
    12/11/2009 7:11 PM
      If the USER-NAME is not already in the Oracle table, add it to it. Then you can capture it.
      John Henley
      Senior Member
      Posts: 3348
      Senior Member
      12/11/2009 7:44 PM
        Usually not, since database login uses a common username unless you set up specific database usernames and map to Lawson users (very few clients do that). Depending on the table on which you are placing the trigger, some times it has a username value. Which table are you looking at?
        Thanks for using the LawsonGuru.com forums!
        John
        You are not authorized to post a reply.