Home » RDBMS Server » Security » Auditing
Auditing [message #29506] Mon, 08 March 2004 20:24 Go to next message
Messages: 7
Registered: March 2004
Junior Member
It would be very appreciable to find the old values which are updated in tables without using triggers.

Foe example

SQL > select em_id,ename from emp;

em_id     ename

1            Deepa

2            Suresh


SQL > update emp set ename = 'Sarada' where em_id=2 ;

SQL > select em_id,ename from emp;

em_id    ename      Class

1           Deepa      First

2           Sarada     First


I want to insert the records(having the old value,new value) into one table called audit_tab .

SQL > select * from audit_tab;

Date            User     Oldvalue              Newvalue

3/10/2004     Senthil    2,suresh,First    2,Sarada,First

Why i want is, if someone modifies some records, it is very difficult to identify in  which record is being modified ..

Thanks in advance,




Re: Auditing [message #29529 is a reply to message #29506] Wed, 10 March 2004 00:29 Go to previous message
Rajeev Katyal
Messages: 55
Registered: April 2002
don't think , there is some way to do it ,without using triggers..anyhow whenever you come to know..please let me know too.
Previous Topic: The problem in using VPD
Next Topic: How to audit dml operations to tables which include old value ,new value without using dml triggers
Goto Forum:

Current Time: Wed Nov 30 07:56:08 CST 2022