[askdba] Re: Record Level Monitoring
- From: "Justin Cave (DDBC)" <jcave@xxxxxxxxxxx>
- To: <askdba@xxxxxxxxxxxxx>
- Date: Fri, 12 Nov 2004 08:02:36 -0700
Generally, you would create a trigger that recorded this sort of data
into an audit trigger. If you need to know who is modifying a row
before they commit their transaction, your audit trigger could be an
autonomous transaction.
Justin Cave <jcave@xxxxxxxxxxx>
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]
On Behalf Of Rajesh Puneyani
Sent: Friday, November 12, 2004 9:51 AM
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Record Level Monitoring
Hi guys,
If I want to see which particular user is updating a particular record
in an application table then how would I do that ?
Based on locking info, I can certainly see which user have row level
lock on that table but how to pin point the user for a particular
value he/she is updating at that time.
Does it make any sense ?
Thank you
Other related posts:
