RE: [MI-L] Auditing edits made to mapinfo tables.

[Terry McDonnell]

Title: Auditing edits made to mapinfo tables.

Mathew

 

Well all I can offer is what seems to be obvious.  Create a table that holds all the audit trail fields and create new records for it every time you amend the database.  If you keep your updates to the database in dedicated procs then that would be the place to also update the audit table.

 

Regards

 

Terry McDonnell

---

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mathew Linnane
Sent: 04 July 2006 06:00
To: Terry McDonnell
Subject: [MI-L] Auditing edits made to mapinfo tables.

I need to create an audit trail of all edits made to a certain mapinfo table. The Audit trail must include user ID, Date, Time etc. Can mapinfo facilitate any form of auditing? All ideas would help.

Regards,

 

 

 

Mathew Linnane

 

GIS/LIS Assets Officer.

Queanbeyan City Council.

257 Crawford Street

Queanbeyan NSW 2620.

Bus: (02) 6298 0205

Fax: (02) 6297 4044

Mob: 0412 565 552

Email: [EMAIL PROTECTED]

 

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

"This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of Queanbeyan City Council, unless otherwise stated.

For the purposes of the Copyright Act, the permission of the holder of copyright in this communication may be taken to have been granted, unless stated otherwise, for the copying or forwarding of this message, as long as both the content of this communication and the purpose for which it is copied or forwarded are work related."

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

 

_______________________________________________
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l