Who's On?

	Membership:
	Latest: Saef
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5226

	People Online:
	Visitors: 469
	Members: 0
	Total: 469

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

Caputuring Lawson Application user for oracle trigger

2 Replies

0 Subscribed to this topic

43 Subscribed to this forum

Sort:

Author

Messages

Todd Mitchell

Veteran Member

Posts: 87

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

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

Posts: 3353

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?