[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.

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