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
Tom_webex
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
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_7004.htm
Re: How to write the trigger? [message #188879 is a reply to message #188719] Tue, 22 August 2006 04:44 Go to previous message
Aju
Messages: 94
Registered: October 2004
Member
How about considering oracle audit trial

http://www.oracle-base.com/articles/10g/Auditing_10gR2.php
Previous Topic: SQL Report using 2 groupings with label
Next Topic: Displaying PAGE N of M through SQL*PLUS Report
Goto Forum:
  


Current Time: Wed Feb 19 11:57:19 CST 2025