Home » RDBMS Server » Security » Is it possible to audit a database changes
Is it possible to audit a database changes [message #29494] Mon, 08 March 2004 09:38 Go to next message
Jaime Stuardo
Messages: 57
Registered: March 2004
Member
Hi all..

I'm wondering now if it is possible to audit database changes. For instance. If I make an UPDATE over certain table.. is it possible to automatically store who has made and the date/time of the changes?

I have Oracle 9i but I hope Oracle 7 and up have something like this.

Thanks

Jaime.
Re: Is it possible to audit a database changes [message #29495 is a reply to message #29494] Mon, 08 March 2004 09:54 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
There is built-in auditing in the database - you just need to turn it on:

Auditing
Previous Topic: Auditing the tables
Next Topic: Database Auditing
Goto Forum:
  


Current Time: Sun Sep 26 23:59:00 CDT 2021