Home » SQL & PL/SQL » SQL & PL/SQL » How to write the trigger?
How to write the trigger? [message #188673] Mon, 21 August 2006 03:17 Go to next message
Messages: 13
Registered: July 2006
Location: China
Junior Member

In my product server,there are 3 tables,they are very important,I want to write a trigger for every table to surveillance who update or delete the recorder of the table,and the trigger will insert the user,ip_address,machine and sql_text to another table,such as audit_tab,I can search the recorder in the audit_tab to check who change the recorder everyday, Thanks!
Re: How to write the trigger? [message #188719 is a reply to message #188673] Mon, 21 August 2006 05:30 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Re: How to write the trigger? [message #188879 is a reply to message #188719] Tue, 22 August 2006 04:44 Go to previous message
Messages: 94
Registered: October 2004
How about considering oracle audit trial

Previous Topic: SQL Report using 2 groupings with label
Next Topic: Displaying PAGE N of M through SQL*PLUS Report
Goto Forum:

Current Time: Fri Oct 21 19:41:18 CDT 2016

Total time taken to generate the page: 0.06181 seconds