Home » RDBMS Server » Security » Auditing
Auditing [message #29506] Mon, 08 March 2004 20:24 Go to next message
sugan
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,

Sugan

 

 

 

Report message to a moderator

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
Member
don't think , there is some way to do it ,without using triggers..anyhow whenever you come to know..please let me know too.

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 09 09:19:12 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.