Can I audit row updates with onaudit
I know I can add UPRW to the _require or user masks. When I do I get an entry
in the logfile like:
ONLN|2009-10-06
13:56:54.000|168.178.104.29|-1|psdev1|informix|0:UPRW:uhpmdcs:244:24117536:872:2
4117536:872
What I need to know is if there is anyway to see what was changed? Can I use
the above information to figure out what the table.row before and after values
are? Is this possible/practical with onaudit or should I be looking elsewhere?
I'm thinking that an update trigger might be a better option.
Thanks
Hi
Please see www.lintel.co.uk/infotrace. No need for triggers so long as your
database is logged.
Regards
David Linthwaite
Lintel Software Consultancy Ltd
IBM Business Partner
Tel.: 01244 357250
Fax.: 01244 357248
mailto:dlinthwaite@lintel.co.uk
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of BEVIS
KENNEDY
Sent: 07 October 2009 14:15
To: ids@iiug.org
Subject: Can I audit row updates with onaudit [17401]
I know I can add UPRW to the _require or user masks. When I do I get an
entry
in the logfile like:
ONLN|2009-10-06
13:56:54.000|168.178.104.29|-1|psdev1|informix|0:UPRW:uhpmdcs:244:24117536:8
72:24117536:872
What I need to know is if there is anyway to see what was changed? Can I use
the above information to figure out what the table.row before and after
values
are? Is this possible/practical with onaudit or should I be looking
elsewhere?
I'm thinking that an update trigger might be a better option.
Thanks
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
An update trigger is probably the way to go, auditing isn't meant for tracking
the before and after images of rows
> To: ids@iiug.org
> From: bkennedy@utah.gov
> Subject: Can I audit row updates with onaudit [17401]
> Date: Wed, 7 Oct 2009 09:15:00 -0400
>
> I know I can add UPRW to the _require or user masks. When I do I get an entry
> in the logfile like:
>
> ONLN|2009-10-06
>
13:56:54.000|168.178.104.29|-1|psdev1|informix|0:UPRW:uhpmdcs:244:24117536:872:2
4117536:872
>
> What I need to know is if there is anyway to see what was changed? Can I use
> the above information to figure out what the table.row before and after
values
> are? Is this possible/practical with onaudit or should I be looking
elsewhere?
>
> I'm thinking that an update trigger might be a better option.
>
> Thanks
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
_________________________________________________________________
Windows Live: Friends get your Flickr, Yelp, and Digg updates when they e-mail
you.
http://www.microsoft.com/windows/windowslive/see-it-in-action/social-network-bas
ics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-za:SI_SB_3:092010
Assuming you have a logging database, for insert, updates and deletes
you can search your logical logs (using onlog) for the specific
modifications.
The logical logs contain the data that was modified.
If you want to see the data that was selected, then you will need to use
Point
in Time Table Level Restore and restore the table to the time when the
user selected the data and view the records.
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 10/07/2009 06:15:00 AM:
> [image removed]
>
> Can I audit row updates with onaudit [17401]
>
> BEVIS KENNEDY
>
> to:
>
> ids
>
> 10/07/2009 06:15 AM
>
> Sent by:
>
> ids-bounces@iiug.org
>
> Please respond to ids
>
> I know I can add UPRW to the _require or user masks. When I do I getan
entry
> in the logfile like:
>
> ONLN|2009-10-06
> 13:56:54.000|168.178.104.29|-1|psdev1|informix|0:UPRW:uhpmdcs:244:
> 24117536:872:24117536:872
>
> What I need to know is if there is anyway to see what was changed? Can I
use
> the above information to figure out what the table.row before and
> after values
> are? Is this possible/practical with onaudit or should I be looking
> elsewhere?
>
> I'm thinking that an update trigger might be a better option.
>
> Thanks
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>