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?

Report message to a moderator

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: 13975
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.

Report message to a moderator

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: 68775
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: iWare Logic becomes Oracle Gold Partner
Next Topic: Why is identifier names limited to 30 characters?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Mar 04 02:23:53 CST 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.