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: 10973
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: 59275
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: 7877
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: Tue Sep 30 07:41:05 CDT 2014

Total time taken to generate the page: 0.09427 seconds