trigger question
From: Mark Loth - DBA <lothmar_at_cscoe.ac.com>
Date: 23 Mar 1995 22:08:02 GMT
Message-ID: <3ksrg2$ccv_at_nsmmfs07.cscoe.ac.com>
Date: 23 Mar 1995 22:08:02 GMT
Message-ID: <3ksrg2$ccv_at_nsmmfs07.cscoe.ac.com>
Recently a need has arisen within a project I support to monitor updates and inserts
for certain database tables. I realize this can be done through auditing, but they
would like to add USER_NAME and SYS_DATE columns to all monitored tables. I have
been asked to write a trigger which would enter the appropriate user_name and sysdate
into these columns for the appropriate row whenever an update or insert occurs on
these tables. I was able to write a trigger for inserts, but I'm having no luck
for updates.
Can some please help? Any help would be greatly appreciated,
Mark
lothmar_at_cscoe.ac.com
Received on Thu Mar 23 1995 - 23:08:02 CET