Home » Other » General » Audit table and Log Table
Audit table and Log Table [message #448754] Thu, 25 March 2010 02:10 Go to next message
Akshita
Messages: 22
Registered: February 2010
Junior Member
Could anyone please explain the difference between an Audit table and a Log table?
Re: Audit table and Log Table [message #448818 is a reply to message #448754] Thu, 25 March 2010 05:23 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Auditing generally means recording specific changes that have been made to data.
Logging generally means recording that some action happened.
Re: Audit table and Log Table [message #448825 is a reply to message #448754] Thu, 25 March 2010 05:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is just a difference on what you want to do with the data, it is not a difference in the tables.

"log" blindly record information without no intention to use them.
"audit" record information in order to check what has been done.
If you have never the intention to read and analyze what inside an audit trail it is just a log.

Regards
Michel
Re: Audit table and Log Table [message #448989 is a reply to message #448754] Fri, 26 March 2010 02:53 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
In my vision (purely a personal interpretation):
Auditing is for management/reporting to be able to trace who changed what.
Logging is for developers to be able to trace what happened and what actions led to a certain outcome.
Previous Topic: iWare Logic becomes Oracle Gold Partner
Next Topic: Why is identifier names limited to 30 characters?
Goto Forum:
  


Current Time: Thu Mar 28 15:48:38 CDT 2024