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: Sat May 03 10:30:06 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.